Returns an array of serial date numbers that represent observed holidays between the two given dates.
Syntax
NxHLDYDates(End_date, Start_date, holidays, Return_type)
- End_date
- is a serial date number that represents the end date.
- Start_date
- is a serial date number that represent the start date. 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, US public calendar is used.
- Return_type
- is a switch to select the return output (1 = count (default), 2 = array of holiday dates).
Method Description 1 count (default) 2 holiday dates
Remarks
- See Holidays for a list of currently supported holidays.
- Most functions automatically convert date values to serial numbers.
- If start_date or end_date is not a valid date, NxHLDYDATES returns the #VALUE! error value
- If the holidays calendar is not recognized (i.e. not currently supported), NxHLDYDATES returns the #VALUE! error value.
- Microsoft 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.
Examples
Example 1:
| Formula | Description (Result) |
|---|---|
| =NxHLDYDates(DATE(2012-12-31),DATE(2012-1-1),,1) | 11 |
| =NxHLDYDates(DATE(2012-12-31),DATE(2012-1-1),,1) | 40910 |
| 40924 | |
| 40959 | |
| 41005 | |
| 41057 | |
| 41094 | |
| 41155 | |
| 41190 | |
| 41225 | |
| 41235 | |
| 41268 |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.