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



  Formula Description (Result)
  =NxWKNDStr(1) 0000011
  =NxWKNDStr(2) 1000001
  =NxWKNDStr(3) 1100000
  =NxWKNDStr(4) 0110000

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments