How To Calculate Days Between Dates In Excel

How to summate working days in Excel

The NETWORKDAYS Role calculates the number of workdays between two dates in Excel. When using the function, the number of weekends are automatically excluded. It also allows yous to skip specified holidays and simply count business days. It is categorized in Excel as a Date/Fourth dimension Function Functions List of the well-nigh of import Excel functions for financial analysts. This cheat canvas covers 100s of functions that are critical to know every bit an Excel analyst . Y'all can use this formula to calculate working days in Excel between two dates.

In finance Finance CFI's Finance Manufactures are designed every bit cocky-study guides to acquire important finance concepts online at your own pace. Browse hundreds of articles! and accounting, the internet 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 concern 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 statement) – Start_date can either exist earlier than end_date, later than end_date, or same as end_date.
End_date (required argument) – The stop 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 comprise the vacation 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 Office in Excel?

Allow's run into a few examples to understand how the NETWORKDAYS function to calculate working days in Excel.

Example 1 – Working days between 2 dates

Suppose we wish to calculate the workdays or business days from January 15, 2017 to January 21, 2018. The holidays in between are:

Nov 23, 2017 – Thanksgiving Solar day
Dec 25, 2017 – Christmas Day
Jan 1, 2018 – New year's Day

To calculate the number of working days, we employ the following role:

NETWORKDAYS Function

Using the formula above, we will get the number of working days as 262, equally shown below.

NETWORKDAYS Function - Example

Pointers most the NETWORKDAYS function

Negative return value – If the start date is later than the terminate date, the office volition return a negative value.
The NETWORKDAYS function volition include both the start date and finish date when calculating work days. So, if nosotros give NETWORKDAYS the same date for start date and terminate date, it volition return ane.
#VALUE! error – Occurs when any of the given arguments is not a valid engagement.
If we wish to utilise weekends other than Saturday and Sunday, nosotros need to utilize the NETWORKDAYS.INTL office.

Click here to download the sample Excel file

Additional resource

Thanks for reading CFI's guide to of import Excel functions! By taking the time to learn and master these functions, you lot'll significantly speed upward your fiscal analysis. To learn more, check out these additional CFI resources:

Excel Functions for Finance Excel for Finance This Excel for Finance guide will teach the top x formulas and functions yous must know to be a keen fiscal analyst in Excel.
Advanced Excel Formulas Class
Advanced Excel Formulas You Must Know Advanced Excel Formulas Must Know These avant-garde Excel formulas are critical to know and will take your financial analysis skills to the next level. Download our free Excel ebook!
Excel Shortcuts for PC and Mac Excel Shortcuts PC Mac Excel Shortcuts - List of the well-nigh of import & common MS Excel shortcuts for PC & Mac users, finance, bookkeeping professions. Keyboard shortcuts speed upward your modeling skills and relieve time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts