Examines a given date for weekends and holidays (non-working days), and returns FALSE if it falls on a non-working day; otherwise it returns TRUE.
Syntax
NxIsWorkDay(date, holidays, Weekends)
- date
- is the serial number that represents a given day. If missing, the current date is used.
- holidays
- is an array of holiday dates, holiday codes (e.g. NYD,PRS), a calendar code(e.g. US, GBP, NYMEX) or a combination of them. If missing, the U.S. government calendar is used.
- Weekends
- is the weekend number(1-7,11-17) or a 7-character string code. If missing, the Western weekend (i.e. 1, "Saturday, Sunday") is used.
Remarks
- If the given date is not valid, NxISWORKDAY returns the #VALUE! error.
- If an unsupported calendar is used, NxISWORKDAY returns the #VALUE! error.
- If the holidays are passed as an array of dates, the default weekend is used (i.e. 1, "Saturday, Sunday").
- For more weekend conventions, see the Weekend category.
- For a full list of supported holidays, see the Holiday category.
- For a full list of supported calendars, see the Calendar category.
- 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: The Saudi Arabia calendar (SAU) does not celebrate the Western New Year's Day, so 01/02/2012 is a working day.
| Formula | Description (Result) |
|---|---|
| =NxIsWorkDay(DATE(2012,8,23)) | TRUE |
| =NxIsWorkDay(DATE(2012,5,28)) | FALSE |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.