How to determine the number of workday between two periods?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Referring to the post in General Question.

Does anyone know how to determine the number of workdays between two
periods? such as today in cell a1, and 26-Feb-2005 in cell b1, the number of
workdays in cell c1.
Does anyone have any suggestion?
Thank you in advance
Eric Choi
 
Does anyone know how to determine the number of workdays between two
periods? such as today in cell a1, and 26-Feb-2005 in cell b1, the number of
workdays in cell c1. Does anyone have any suggestion?
Click to expand...

Depends on what you call a "workday". Use Excel Help to learn about
NETWORKDAYS(). If its definition of "workday" meets your needs, the
solution might be simple:

=networkdays(b1,a1)

You might want to add the "holidays" argument.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the number of workday between two periods? 1
Calculating new date by entering number of additional workdays 1
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
WORKDAY 8
WORKDAY Help 5
workday with month functions 5
Count the number of workday in a month 5
How to determine the number of month between 2 periods? 1

Back
Top