NxCALWKND - Weekend for a Given Calendar

Returns the weekend number of a 7 character string, calendar code, or currency. Each character represents a day of the week, beginning with Monday.

 

Syntax

NxCALWKND(calendar, Return_type)

calendaris the calendar code (e.g. US, NYSE, CBT), name or alias. If missing, the US Government calendar is used. It may also be the country code or currency.

Return_type is a switch to select the return output (1 = weekend number (default), 2 = 7-character string code).

 

Remarks

  1. See Calendars for a list of currently supported calendars.
  2. If the calendar is not recognized (i.e. not supported), NxCALWKND returns the #VALUE! error value.

Examples

  Formula Description (Result)
  =NxCALWKND (US,2) 0000011

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments