Returns the weekend number of a 7 character string, calendar code, or currency. Each character represents a day of the week, beginning with Monday.
Syntax
NxCALWKND(calendar, Return_type)
- calendar
- is the calendar code (e.g. US, NYSE, CBT), name or alias. If missing, the US Government calendar is used. It may also be the country code or currency.
- Return_type
- is a switch to select the return output (1 = weekend number (default), 2 = 7-character string code).
Remarks
- See Calendars for a list of currently supported calendars.
- If the calendar is not recognized (i.e. not supported), NxCALWKND returns the #VALUE! error value.
Examples
Example 1:
Formula | Description (Result) |
---|---|
=NxCALWKND (US,2) | 0000011 |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.