| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting and error while calculate business hours between 2 dates with holidays. | Excel Worksheet Functions | |||
| calculating days + holidays | Excel Worksheet Functions | |||
| how do I calculate the time service minus holidays? | Excel Worksheet Functions | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Threaded Mode
