Calculating Working Days
 

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

Take a look at NETWORKDAYS() function


"will" wrote in message
...
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

Hi Will

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

Cheers
JulieD

"will" wrote in message
...
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

=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)


"will" wrote in message
...
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

Many thanks everyone.

Will

"Bob Phillips" wrote:

=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)


"will" wrote in message
...
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

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