Returns the weekend-number (1-7 or 11-17) for a given country or a weekend code.
Syntax
NxWKNDNo(code)
- code
- is either the seven-character weekend code (e.g. 1000001) or the country ISO code (e.g. US, GBP, CAD, etc.). If missing, US is used.
Remarks
- See Weekend for a list of supported weekends and their string values.
- If weekend string value is not a valid (supported) code, NxWKNDNo returns the #VALUE! error value.
- If the input string is not 2, 3 or 7 characters long, NxWKNDNo returns the #VALUE! error value.
- NxWKNDNo trims leading and trailing White-spaces in the input string.
Examples
Example 1:
| Formula | Description (Result) |
|---|---|
| =NxWKNDNo(1000001) | 2 |
| =NxWKNDNo(1100000) | 3 |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.