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/time value(s) |
| Allow partial weeks [True/False]. Optional; default is True. |
Output
Week of the year for each input date
Example
Last updated