WEEKNUM function

WEEKNUM calculates the week number of the year for the internal date value.

Syntax

WEEKNUM (number,mode)

Example

January 1, 1995 was a Sunday (mode value of 1). Both =WEEKNUM("1995-01-01",1)and and =WEEKNUM("1995-01-01",2)and return 1 in IBM Docs. Even when the week begins on Monday, January 1 (Sunday) is computed to belong to the first week of the year.




Trademarks | IBM Connections wiki