WEEK

Calculates the week for a given date

WEEK( date )

Returns the week of the year for the given date or array of dates. Week is given as an integer, ranging from 1 to 53.

Arguments

Argument	Description
date	Date/time value(s)
partial week	Allow partial weeks [True/False]. Optional; default is True.

Output

Week of the year for each input date

Example