Calculating no of work days between two dates

F

fluffywhitedoh

Please advise how to calculate the number of work days (excludin
weekeends and holidays) between two date
 
B

Bob Phillips

=NETWORKDAYS(start_date,end_date,holidays)

holidays is a range of holiday dates.

You will need to have the Analysis Toolpak installed, Tools>Addins, and
cheek it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"fluffywhitedoh"
 
Top