NxHLDYDate - Date of a given holiday in a given year

Returns the date serial number that represents the holiday in the given year.

 

Syntax

NxHLDYDate(date, holidays, Return_type)

date is the serial date number that represents the date of concern. If missing or omitted, the current date is used.

holidays is an array of holiday codes (e.g. NYD, USA-PRS, etc). If missing, the holidays from the US public calendar is used.

Return_type is a switch to select the return output (1 = next holiday, 2= last holiday).

Method Description
1 last holiday (default) before the given date
2 next holiday after the given date
 

Remarks

  1. See Holidays for a list of currently supported holidays.
  2. 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.
  3. Most functions automatically convert date values to serial numbers.

Examples

  Formula Description (Result)
  =NxHLDYDate(DATE(2012-12-25)) 40543
  =NxHLDYDate(DATE(2012-12-27),,1) 40543
  =NxHLDYDate(DATE(2012-12-27),,2) 40507

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments