Calculating number of weekdays

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Could someone please tell me how to calculate the number
of weekdays between two dates eg. between 21/09/2001
and 14/02/2002. I would also like to know how to(a) add
and subtract weekdays to a particular date and (b)convert
weekdays into calendar days eg.101 weekdays is
approximately 144 calendar days. In other words I need to
calculate a time period either with weekends included or
weekends excluded.
Thanks for your help
Tom
 
Tom,

You need NETWORKDAYS and the WORKDAY functions. The syntax is
=NETWORKDAYS(start,end,holidays)
=WORKDAY(start,days,holidays)

where holidays is either an array of dates, or a named range of dates. This
allows holidays to be ignored in the calculations.

They are part of the Analysis Toolpak, so that needs to be installed.
 
Back
Top