Week()

Working with Formulas > Functions Used in Formulas > Date/Time Functions > Week()

WEEK() returns the week of the year containing the input date. If a null date is specified, the function returns zero.

Function Format

WEEK(date) 

Return Value

WEEK() returns an integer 

Examples

WEEK(DATE("07/04/2007")) = 27 

WEEK(DATE(2007, 12, 25)) = 52