Calculating business days minus holidays
 

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?

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?

Calculating business days minus holidays
 

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, D1:D10)

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

Regards,

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

"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?

Calculating business days minus holidays
 

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?

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?