Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i am trying to calculate how many days between 2 dates that excludes
holidays and weekends. Is there a formula for that. Thanks, |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Look at excel's help for =networkdays().
If you're using xl2003 and below, you'll have to have the analysis toolpak loaded. Tools|Addins check analysis toolpak Depending on how excel was installed, you may need the distribution disks. Joe H. wrote: i am trying to calculate how many days between 2 dates that excludes holidays and weekends. Is there a formula for that. Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding workdays | Excel Worksheet Functions | |||
Workdays Formula | Excel Worksheet Functions | |||
Workdays Function | Excel Worksheet Functions | |||
Workdays Function | Excel Worksheet Functions | |||
Workdays | Excel Discussion (Misc queries) |