Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workdays
I am using Days360 function within Excel to extract the
number of days that an item is open. However, the purist in me would like to exclude weekends and holidays so that we have a true workdays open calculation. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workdays
John,
Use the NETWORKDAYS to determine the number of weekdays between two dates. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John Flynn" wrote in message ... I am using Days360 function within Excel to extract the number of days that an item is open. However, the purist in me would like to exclude weekends and holidays so that we have a true workdays open calculation. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workdays
See the Excel help for the NETWORKDAYS and the WORKDAY function
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "John Flynn" wrote in message ... I am using Days360 function within Excel to extract the number of days that an item is open. However, the purist in me would like to exclude weekends and holidays so that we have a true workdays open calculation. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Workdays | Excel Worksheet Functions | |||
Workdays | Excel Worksheet Functions | |||
Net Workdays | Excel Discussion (Misc queries) | |||
Workdays | Excel Worksheet Functions | |||
Workdays | Excel Discussion (Misc queries) |