Business Automation and Software Blog

Excel Tips and Tricks: Workdays

Posted by Robert Baran on Fri, Nov 23, 2012 @ 01:16 PM

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:

Excel Tips and Tricks

2. Select cell A7.

3. Select Formulas>Date & Time>NETWORKDAYS. Refer to the screen shot below:

Excel Tips and Tricks

4. Enter as below and select Ok.

Excel Tips and Tricks

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.

Contact PositiveVision ► ► for a Complimentary  Reporting Consultation

Topics: Business Reporting, Excel Tips and Tricks