Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
How to Calculate Working Days in Excel
The NETWORKDAYS Function[1] calculates the number of workdays between two dates in Excel. When using the function, the number of weekends are automatically excluded. It also allows you to skip specified holidays and only count business days. It is categorized in Excel as a Date/Time Function. You can use this formula to calculate working days in Excel between two dates.
In finance and accounting, the net workdays function is useful in calculating employee benefits that accrue based on days worked, the number of working days available during a project, or the number of business days required to resolve a ticket raised by a customer, etc.
Formula
=NETWORKDAYS(start_date, end_date, [holidays])
The function uses the following arguments:
Start_date (required argument) – Start_date can either be earlier than end_date, later than end_date, or same as end_date.
End_date (required argument) – The end date.
Holidays (optional argument) – This specifies the list of holidays that should be excluded from the work days calculation. We can enter it as a range of cells that contain the holiday dates (that is F2:F4) or as a list of serial numbers that represent the holiday dates.
It is recommended that the start_date, end_date and [holidays] arguments are entered as either:
References to cells containing dates; or
Dates returned from formulas.
How to calculate NETWORKDAYS Function in Excel?
Let’s see a few examples to understand how the NETWORKDAYS function to calculate working days in Excel.
Example 1 – Working days between two dates
Suppose we wish to calculate the workdays or business days from January 15, 2017 to January 21, 2018. The holidays in between are:
November 23, 2017 – Thanksgiving Day
December 25, 2017 – Christmas Day
January 1, 2018 – New Year’s Day
To calculate the number of working days, we use the following function:
Using the formula above, we will get the number of working days as 262, as shown below.
Pointers about the NETWORKDAYS function
Negative return value – If the start date is later than the end date, the function will return a negative value.
The NETWORKDAYS function will include both the start date and end date when calculating work days. So, if we give NETWORKDAYS the same date for start date and end date, it will return 1.
#VALUE! error – Occurs when any of the given arguments is not a valid date.
If we wish to use weekends other than Saturday and Sunday, we need to use the NETWORKDAYS.INTL function.
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.