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
|