How to determine the number of workday between two periods?
 

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

How to determine the number of workday between two periods?
 

On Feb 11, 10:50 pm, Eric wrote:
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?

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.