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

Example 1:

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

Comments

Article is closed for comments.

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