NETWORKDAYS
Formulas / NETWORKDAYSCalculate the number of working days between two dates.
NETWORKDAYS(start_date,end_date,[holidays])
- start_date - required, the date for which the difference is to be calculated, starting from the current date
- end_date - required
- weekend - [OPTIONAL] the number of days in the week that are weekend days
- holidays - [OPTIONAL]
Examples
NETWORKDAYS(start_date, end_date, 7)You can use the NETWORKDAYS function to count the number of whole weeks between two dates. To count the number of whole weeks between two dates, you would use the preceding formula, where 7 is the number of days in a week. This formula will return the number of whole weeks between the two dates, excluding any holidays.
NETWORKDAYS(start_date, end_date, "12/25/2020, 1/1/2021")You can also use the NETWORKDAYS function to exclude holidays from the total number of days between two dates. To exclude holidays, you would need to list the dates of the holidays in the [holidays] argument. For example, if you wanted to exclude the dates of Christmas and New Year's from the total number of days, you would use the preceding formula, where 12/25/2020 and 1/1/2021 are the dates of Christmas and New Year's.
Summary
The NETWORKDAYS function is used to calculate the number of working days between two dates, excluding weekends and holidays. It can be used to calculate employee benefits based on the number of days worked.
- The NETWORKDAYS function calculates the number of working days between two dates, automatically excluding weekends.
- It can also optionally exclude holidays from the calculation by passing a list of dates.
- The start and end dates are included in the calculation of workdays.
Frequently Asked Questions
What is the NETWORKDAYS function?
What arguments does the NETWORKDAYS function require?
What is the best way to enter dates into the NETWORKDAYS function?
