NxFindHLDY - Holiday that falls on a given date

Returns the holiday code that falls on the given date.


NxFindHLDY(date, holidays)
is the serial date number that represent the date of concern. If missing or omitted, the current date is used.
is an array of holiday codes (e.g. NYD, USA-PRS, etc). If missing, the US public calendar is used.


  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.


Example 1:

Formula Description (Result)
=NxFindHLDY(DATE(2010-07-04)) FALSE
=NxFindHLDY(DATE(2010-07-05)) TRUE
=NxFindHLDY(DATE(2010-12-25)) FALSE


Files Examples


External Links


Article is closed for comments.

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