NxWKNDUR - Weekend Duration

Returns the duration (in calendar days) of the (long) weekend that a given day falls on.


NxWKNDUR(date, holidays, weekends)
is the serial date number that represents the date of concern. If missing or omitted, the current date is used.
is an array of holiday dates, holidays (e.g. NYD,PRS) codes or a calendar (e.g. USA, GBP, JPN) code. If missing, the U.S. federal holidays are used.
is the weekend-number or a seven-character string value. This argument is used if the holidays-argument is specified as an array of dates.


  1. See Holidays for a list of currently supported holidays.
  2. See Calendars for a list of currently supported calendars.
  3. Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
  4. Most functions automatically convert date values to serial numbers.
  5. If start_date is not a valid date, NxWKNDUR returns the #VALUE! error value.
  6. If start_date does not fall on, immediately before or after a long weekend, NxWKNDUR returns the #DIV/0! error value.
  7. If Calendar is not recognized (i.e. not supported), NxWKNDUR returns the #VALUE! error value.


Files Examples


External Links


Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful