Returns the seven-character string code for a weekend-number (1-7, 11-17).
Syntax
NxWKNDStr(number)
- number
- is the weekend number (1-7, 11-17). If missing, 1 is used.
Remarks
- If number is not a valid (supported), NxWKNDString returns the #VALUE! error value.
- See Weekend for a list of supported weekends and their designated numbers/codes.
Examples
Example 1:
Formula | Description (Result) |
---|---|
=NxWKNDStr(1) | 0000011 |
=NxWKNDStr(2) | 1000001 |
=NxWKNDStr(3) | 1100000 |
=NxWKNDStr(4) | 0110000 |
Files Examples
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068
Comments
Article is closed for comments.