ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate dates between 2 dates (https://www.excelbanter.com/excel-discussion-misc-queries/185651-calculate-dates-between-2-dates.html)

Wanna Learn

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

ShaneDevenshire

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