Excel Tips and Tricks / Business Reporting Question: How can I calculate the number of workdays between two dates? The usual off days are Saturday, Sunday and public holidays.
Answer: By using the Networkdays function
Why: To calculate the number of workdays between two dates
Applies To: Excel (2010, 2007):
1. The data below will be used for illustration purposes:
2. Select cell A7.
3. Select Formulas>Date & Time>NETWORKDAYS. Refer to the screen shot below:
4. Enter as below and select Ok.
The number of workdays between the two given dates is 78. The formula can also be entered in this way:
=NETWORKDAYS (A3,A4,A5:A6). The formula subtracts the usual weekend days and any specified holidays from the difference between the start and end dates of the project.