NxIsHoliday - Examine a given date for holidays

Returns TRUE when the given date falls on a holiday.

 

Syntax

NxIsHoliday(date, holidays)

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

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

 

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.
  4. If start_date is not a valid date, NxIsHoliday returns the #VALUE! error value.
  5. If Calendar is not recognized (i.e. not supported), NxIsHoliday returns the #VALUE! error value.

Examples

  Formula Description (Result)
  =NxIsHoliday(DATE(2012-5-28)) TRUE
  =NxIsHoliday(DATE(2010-12-25)) FALSE
  =NxIsHoliday(DATE(2010-12-8)) FALSE

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments