Excel NETWORKDAYS function

Summary

The Excel NETWORKDAYS function calculates the number of weekdays between two dates, automatically excluding weekends (Saturdays and Sundays). It can also optionally exclude a list of holidays. This function is widely used in business for calculating working days in project planning, employee benefits accrual, or deadline tracking.
Syntax
				
					=NETWORKDAYS(start_date, end_date, [holidays])
				
			
  • start_date: The beginning of the date range.
  • end_date: The end of the date range.
  • holidays: [Optional] A range of dates to be excluded as holidays.
Return value
The number of weekdays between the start and end dates.

How to use

Use NETWORKDAYS to find out how many weekdays are there in a specific period, excluding weekends and optionally excluding specified holidays. This function is especially helpful for HR in calculating leaves, for project managers in scheduling tasks, or for finance in calculating interest over working days.

Examples

Simple NETWORKDAYS
Basic Working Days Calculation: Calculating the number of working days between two dates:
				
					=NETWORKDAYS("2021-01-01", "2021-01-31")
				
			
This formula calculates the number of weekdays in January 2021.
NETWORKDAYS with Holidays
Calculating Working Days Excluding Holidays: Including a range of holidays in the calculation:
				
					=NETWORKDAYS(start_date, end_date, A1:A5)
				
			
Assuming A1:A5 contains a list of holiday dates, this formula calculates the working days between start_date and end_date, excluding those holidays.
NETWORKDAYS for Project Duration
Project Duration in Working Days: Determining the duration of a project in working days:
				
					=NETWORKDAYS(project_start, project_end)
				
			
This formula gives the number of working days from the start to the end of a project, helping in estimating the time required to complete it.

Additional Notes

  • NETWORKDAYS includes both the start date and end date in the count if they fall on a weekday.
  • The function ignores any time values; it only considers whole days.
  • For non-standard weekends (e.g., Friday and Saturday off), consider using the NETWORKDAYS.INTL function.

Related Functions

Excel DATEDIF function

The Excel DATEDIF function calculates the difference between two dates, useful for age, time spans, and precise date calculations.

Excel WORKDAY function

The Excel WORKDAY function adds workdays to a date, skipping weekends, perfect for project deadlines.

Excel WORKDAY.INTL function

The Excel WORKDAY.INTL function adds business days to a date considering custom weekends, suited for international schedules.

Excel NETWORKDAYS.INTL function

The Excel NETWORKDAYS.INTL function calculates workdays between dates with custom weekends, ideal for international scheduling.

Excel DAYS function

The Excel DAYS function calculates the difference in days between two dates, essential for tracking durations and time spans in data analysis.

Content Navigation