NxWKDYOrder - Order of the weekday for a given date

Returns the order of the weekday in the month for a given date. This is the inverse operator of NxNWKDAY.

 

Syntax

NxWKDYOrder(date)

date is the serial date number that represents the given date. If missing, the current date is used.

 

Remarks

  1. Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
  2. Most functions automatically convert date values to serial numbers.

Examples

  Formula Description (Result)
  =NxWKDYOrder(DATE(2012,12,1)) 1
  =NxWKDYOrder(DATE(2012,1,23)) 4
  =NxWKDYOrder(DATE(2012,1,30)) 5

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments