![]() |
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 |
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 |
All times are GMT +1. The time now is 02:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com