NxNetWorkdays - Number of working days in a given date range

Returns the number of whole working days between two dates (inclusive). Working days exclude weekends and any date identified as a holiday.

 

Syntax

NxNetWorkdays(End_date, Start_date, holidays, weekends)

End_dateis the serial date number that represents the end date.

Start_dateis the serial date number that represent the start date. If missing or omitted, the current date is used.

holidays is an array of holiday dates, holiday (e.g. NYD,PRS)/calendar (e.g. USA, GBP, NYMEX) codes or a combination of them. If missing, the US public calendar is used.

weekends is the weekend number (1-7,11-17) or the 7-character string code. If missing, the Western weekend (i.e. 1, "Saturday, Sunday") is used.

 

Remarks

  1. See Holidays for a list of currently supported holidays.
  2. See Calendars for a list of currently supported calendars.
  3. Working days exclude weekends and any dates identified as holidays.
  4. Microsoft 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.
  5. Most functions automatically convert date values to serial numbers.
  6. Dates (i.e. start_date or end_date) should be entered by using the DATE function or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008.
  7. Problems can occur if dates are entered as text.
  8. If start_date or end_date is not a valid date, NxNetWorkdays returns the #VALUE! error value.
  9. If Calendar is not recognized (i.e. not supported), NxNetWorkdays returns the #VALUE! error value.
  10. If start_date is after end_date, NxNetWorkdays returns the #VALUE! error value
  11. CxNetWorkdays is similar to the Microsoft Excel function (NETWORKDAYS), but NxNetWorkdays supports predefined calendars and handles weekend days other than Saturday and Sunday.

Examples

  Formula Description (Result)
  =NxNETWORKDAYS (DATE(2010-12-12),DATE(2009-12-12)) 249
  =NxNETWORKDAYS (DATE(2010-12-12),DATE(2008-12-12)) 498
  =NxNETWORKDAYS (DATE(2010-12-12),DATE(2007-12-12)) 749
  =NxNETWORKDAYS (DATE(2010-12-12),DATE(2006-12-12)) 999

Files Examples

Have more questions? Submit a request

0 Comments