Formulas and Functions
Modifying this control will update this page automatically

NETWORKDAYS

The NETWORKDAYS function returns the number of working days between two dates. Working days exclude weekends and any other specified dates.

NETWORKDAYS(start-date, end-date, exclude-dates)

start-date: The starting date. start-date is a date/time value (the time portion is ignored) or date string.

end-date: The ending date. end-date is a date/time value (the time portion is ignored) or a date string.

exclude-dates: An optional collection of other dates that should be excluded from the count. exclude-dates must contain date/time values or date strings.

Example

Suppose that 11 November 2009 and 26 November 2009 are holidays. If these two values are entered in cells B2 and B3, respectively, you could find the number of workdays in November 2009, excluding these holidays, using the formula:

=NETWORKDAYS("01/11/2009","30/11/2009",B2:B3) returns 19d, the number of working days in November 2009 excluding weekends and the two holidays.

See alsoDATEDIFDAYS360WORKDAY
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.