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.