WEEKNUM function

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


WEEKNUM (number,mode)


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