View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?