NxWKNDStr - Weekend Code

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

  1. If number is not a valid (supported), NxWKNDString returns the #VALUE! error value.
  2. 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

External Links

Comments

Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful