WEEKNUM function

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


WEEKNUM (number,mode)

  • number is the internal date number.
  • mode sets the start of the week and the calculation type; 1 = Sunday, 2 = Monday.


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