View Single Post
  #5   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

The OP already mentioned that he/she used NETWORKDAYS


--


Regards,


Peo Sjoblom



"FSt1" wrote in message
...
hi
and just to add....
networkdays is part of the analysis tool pack. if you have not installed
the
analysis tool pack, you will need your original excel install disk.
to install, on the menu bar....ToolsAddins

regards
FSt1

"Peo Sjoblom" wrote:

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?