Calculating business days minus holidays

[RJ Swain]

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?

 

[Peo Sjoblom]

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

 

[Ron Coderre]

Excel Help on NETWORKDAYS explains.

Just reference a range of cells containing holiday dates in the 3rd argument
(parameter) of the function.

Like this:
A1: StartDate
B1: EndDate

D1: 01-JAN-2007
etc
D10: 25-DEC-2007

Then use this formula:
=NETWORKDAYS(A1,B1, D110)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[FSt1]

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....Tools>Addins

regards
FSt1

 

[Peo Sjoblom]

The OP already mentioned that he/she used NETWORKDAYS


--


Regards,


Peo Sjoblom