NxCALHolidays - Supported Holidays in a Calendar

Returns an array of the holidays' names and codes as defined for the given calendar.

 

Syntax

NxCALHolidays(calendar, Return_type)

calendaris the calendar code (e.g. US, NYSE, CBT), name or alias. If missing, the US Government calendar is used.

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 Holidays for a list of currently supported Holidays.
  2. See Calendars for a list of currently supported calendars.
  3. The number in the first cell is always the number of cells in the array (e.g., "US" returns "11," so there are 11 holiday names for the US calendar).
  4. To view the supported holiday names within the cell, select the first cell and the number of cells in the array. Press F2, then press SHIFT+CTRL+ENTER.
  5. If the calendar is not recognized (i.e. not supported), NxCALHolidays returns the #VALUE! error value.

Examples

  Formula Description (Result)
  =NxCALHolidays (CAD) CAN-NYD
    CAN-GDF
    CAN-VICTORIA
    CAN-CANADA
    CAN-CIVIC
    CAN-LABOR
    CAN-THK
    CAN-REM
    CAN-CHR
    CAN-BOX

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments