How to Use the NETWORKDAYS Function in Excel
Today, we’ll explore the NETWORKDAYS function, a handy tool available in both Microsoft Excel and Google Sheets. This function calculates the number of working days between two specified dates, excluding weekends and, optionally, a list of specified holidays.
How NETWORKDAYS Works
The syntax for the NETWORKDAYS function is as follows:
NETWORKDAYS(start_date, end_date, [holidays])- start_date: The starting date of the period for which you want to count working days.
- end_date: The ending date of the period for which you want to count working days.
- holidays (optional): An optional list of dates that should be excluded from the working day count, such as public holidays.
Examples of Using NETWORKDAYS
Here are some examples to demonstrate the use of the NETWORKDAYS function:
| Example | Description | Formula | Result |
|---|---|---|---|
| Example 1 | Calculate the number of working days between two dates, excluding any holidays. | =NETWORKDAYS(“2022-01-01”, “2022-01-15”) | 11 (assuming weekends are Saturday and Sunday) |
| Example 2 | Calculate working days between two dates while excluding a holiday on January 6, 2022. | =NETWORKDAYS(“2022-01-01”, “2022-01-15”, “2022-01-06”) | 10 |
Implementing NETWORKDAYS in Excel and Google Sheets
Adding the NETWORKDAYS function to your Excel or Google Sheets worksheet is straightforward. Simply follow these steps:
Excel
- Select the cell where you want to display the result.
- Input the formula
=NETWORKDAYS(start_date, end_date, [holidays]). - Press Enter to execute the formula.
Google Sheets
- Select the cell where the result should be shown.
- Type in the formula
=NETWORKDAYS(start_date, end_date, [holidays]). - Hit Enter to complete.
You have now successfully used the NETWORKDAYS function to calculate working days in both Excel and Google Sheets.
More information: https://support.microsoft.com/en-us/office/networkdays-function-48e717bf-a7a3-495f-969e-5005e3eb18e7
Other functions
Returns the serial number of a particular date
Calculates the number of days, months, or years between two dates This function is useful in formulas where you need to calculate an age
Converts a date in the form of text to a serial number
Converts a serial number to a day of the month
Returns the number of days between two dates
Calculates the number of days between two dates based on a 360-day year
Returns the serial number of the date that is the indicated number of months before or after the start date
Returns the serial number of the last day of the month before or after a specified number of months
Converts a serial number to an hour
Returns the number of the ISO week number of the year for a given date
Converts a serial number to a minute
Converts a serial number to a month
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
Returns the serial number of the current date and time
Converts a serial number to a second
Returns the serial number of a particular time
Converts a time in the form of text to a serial number
Returns the serial number of today's date
Converts a serial number to a day of the week
Converts a serial number to a number representing where the week falls numerically with a year
Returns the serial number of the date before or after a specified number of workdays
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
Converts a serial number to a year
Returns the year fraction representing the number of whole days between start_date and end_date