How to determine the number of workday between two periods?

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
 
J

joeu2004

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
How to determine the number of month between 2 periods? 1
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
How to determine the value? 1
Calculating new date by entering number of additional workdays 1
Count the number of workday in a month 5
Calculating number of periods 2
How to determine the value? 8

Top