Calculating number of weekdays

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
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Days in a specific month 2
DateDiff counting weekdays only 10
Extrapolating the number of days 1
Template for calculating different number of days between 2 dates 1
Calculate weekdays only 1
Calculating weekdays in Access 5
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13
Subtracting number of days excluding the weekend 2

Top