How to determine the number of workday between two periods?

E

Eric

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

JE McGimpsey

How about:

C1: =NETWORKDAYS(A1,B1)

NETWORKDAYS is in the Analysis Toolpak Add-in (Tools/Add-ins...)
 
Top