Category:Date and time
Returns the number of weeks within a year that corresponds to a specified date.
WEEKNUM (serial_num, type)
- num_de_serie (mandatory ): The date from which the week will be determined within the year.
- type (required ): The starting day of the week [1 = Sunday, 2 = Monday]
WEEK NUMBER (“ 09/20/2009 ”, 1) = 39
WEEK NUMBER (“ 09/20/2009 ”, 2) = 38