Calculating Working Days

[Guest]

Can anyone advise me how to calculate the number of working days? Obviously
calculating the number of days between 2 dates is easy, but is there an
expression to use which returns the number of working days?

Many thanks.

Will

 

[N Harkawat]

Take a look at NETWORKDAYS() function

 

[JulieD]

Hi Will

check out the NETWORKDAYS function in help ... it's part of the analysis
tool-pak add-in

Cheers
JulieD

 

[Bob Phillips]

=NETWORKDAYS(start_date,end_date,holidays)

holidays is an optional argument to avoid counting holidays. This would be a
worksheet range.

This function is part of the Analysis Toolpak, so you need that to be
installed.


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Many thanks everyone.

Will

=NETWORKDAYS(start_date,end_date,holidays)

holidays is an optional argument to avoid counting holidays. This would be a
worksheet range.

This function is part of the Analysis Toolpak, so you need that to be
installed.


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bernd Plumhoff]

Other approach (without holidays, calculating from 24:00
of first date to 24:00 of second date):

=(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY
(A1,2))+MIN(5,WEEKDAY(A2,2))

HTH,
Bernd