WEEKOFYEAR

Returns a week of a year value given a specific date.  Returns a numeric value (0-53) where the first week of a year is 1, the second is 2, and so forth. 

Syntax

WEEKOFYEAR(date)

Arguments

date	Date value to extract the week of the year value. Use the format (year, month, day)

Example

WEEKOFYEAR(DATE(2002,7,4)) returns 26 since July 4, 2002 is in the 26th week of 2002.