Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate dates between 2 dates
Hello How do I calculate the number of business days between 2 days,
example how many business days are there between 1-9-08 and 1-3-08 thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate dates between 2 dates
You can use the =NETWORKDAYS(A3,A4) function. You must attach the Analysis
ToolPak add-in to use this function. Tools, Add-Ins. This function assumes workdays are M-F. If you also need to exclude other days (holidays) there is a 3rd arguments. -- Cheers, Shane Devenshire Microsoft Excel MVP "Wanna Learn" wrote: Hello How do I calculate the number of business days between 2 days, example how many business days are there between 1-9-08 and 1-3-08 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I calculate dates? | New Users to Excel | |||
Calculate dates | Excel Worksheet Functions | |||
calculate dates | Excel Discussion (Misc queries) | |||
How do I calculate an age from 2 dates? | Excel Worksheet Functions | |||
How do I calculate dates? | Excel Worksheet Functions |