NxWKNDNo - Weekend Convention Number

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

  1. See Weekend for a list of supported weekends and their string values.
  2. If weekend string value is not a valid (supported) code, NxWKNDNo returns the #VALUE! error value.
  3. If the input string is not 2, 3 or 7 characters long, NxWKNDNo returns the #VALUE! error value.
  4. NxWKNDNo trims leading and trailing White-spaces in the input string.

Examples

  Formula Description (Result)
  =NxWKNDNo(1000001) 2
  =NxWKNDNo(1100000) 3

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments