Calculating business days minus holidays
If you look in help you will see that the you need to put the public
holidays in the formula,
preferably by using a range where you type in the holidays
=NETWORKDAYS(start,end,holidays)
--
Regards,
Peo Sjoblom
"RJ Swain" wrote in message
...
Thank you for helping,
I am working on a sheet now where the user will input the current month
(01/01/07) in A1 and it shows the number of business days in C5 using the
networkday command. How can I have the sheet subtract holidays from the
business day total for the month?
|