NxWorkday - Advance a given date N-Working Days

Returns the serial date number that represents the date that falls after the start date by a given number of working days.

 

Syntax

NxWorkday(days, start_date, holidays, weekends)

days is the whole number of working days (non-weekends and non-holidays) to advance to.

start_date is the serial date number that represents the start date. If missing or omitted, the current date is used.

holidays is an array of holiday serial date numbers, 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 default weekday and weekends convention. Argument is given as a weekend-number (1-7, 11-17) or a 7-character string code. If missing, the Western weekend convention is used.

 

Remarks

  1. 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.
  2. Most functions automatically convert date values to serial numbers.
  3. If Start_date is not a valid date, NxWORKDAY returns the #VALUE! error value.
  4. If days is not an integer, it is truncated.
  5. If Calendar is not recognized (i.e. not supported), NxWORKDAY returns the #VALUE! error value.
  6. If the final date is not a valid date, NxWORKDAY returns the #NUM! error value.

Examples

  Formula Description (Result)
  =NxWORKDAY (10,DATE(2010-12-12)) 40539
  =NxWORKDAY (20,DATE(2010-12-12)) 40554
  =NxWORKDAY (30,DATE(2010-12-12)) 40569
  =NxWORKDAY (40,DATE(2010-12-12)) 40583

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments