As an Excel or data analyst, dates in datasets are common and usually involve some work to take from raw data stage into meaningful reports. Employee datasets, sales datasets and the like will often require date calculations and one useful technique is calculating the number of working days.
A lot of businesses such as financial organisations are still based on a Mon-Fri working week so there are times where working days, just counting 5 days a week, Monday to Friday, come in use.
One good example would be a report showing employee attendance rates by month. For that the Excel analyst would have to calculate the number of working days in each month as if an employee works Monday to Friday it would be unfair to calculate their attendance percentage based off of a Monday to Sunday week.
So how do you calculate the number of working days between 2 dates in Excel 2010?
In order to calculate the number of working days between 2 dates in Excel 2010 you need to use the NETWORKDAYS function.
The NETWORKDAYS function takes the format:
=NETWORKDAYS(Start Date, End Date, [Holidays])
This is where the start and end dates are the 2 dates in Excel that you need to calculate the number of working days between and holidays is an optional extra to include bank holidays or certain non-work days that may be relevant to your organisation.
To use the function correctly you can either specify the dates within the formula like so:
Don’t forget to include the quotation marks around the dates otherwise Excel will not recognise them correctly.
Or, you can use the more common practice of using cells as a reference in your formula like so:
And that’s all there is to it. You can now add another Excel technique to your ever-growing skill set