How to determine the number of workday between two periods?

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

Guest

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 about:

C1: =NETWORKDAYS(A1,B1)

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