NxHolidays - Supported Holidays with a given prefix

Returns an array of the matching supported holiday codes.

 

Syntax

NxHolidays(prefix, Return_type)

prefix is the holiday name/prefix to search for. If missing, the full list of holidays will be returned.

Return_type is a switch to select the return output (1 = count (default), 2 = array of holiday codes).

Method Description
1 count (default)
2 holiday codes
 

Remarks

  1. See Holiday for a list of currently supported holidays.
  2. A full name of a holiday is prefixed with a country code, followed by hyphen (-), colon (:) or forward slash (/).
  3. If the holiday is not recognized (i.e. not supported), NxHolidays will return the #VALUE! error value.

Examples

  Formula Description (Result)
  =NxHolidays() All currently supported holidays
  =NxHolidays("SAU/") SAU-NATION, SAU-FITER, SAU-ADHA
  =NxHolidays("EUC/") EUC-CHR, EUC-BOX, EUC-MAY, EUC-GDF, EUC-EAST, EUC-NYD

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments