These docs are for v1.0. Click to read the latest docs for v1.2.

WEEK

Gets the week component of the specified date. For more information see ISO Week Date.

Syntax

=WEEK(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

=WEEK(DATE(2020, 2, 3, 4, 5))6
Gets the week component 6 from the specified date Feb 3, 2020 4:05 AM

=WEEK(DATE(2020, 4, 5, 6, 7))14
Gets the week component 14 from the specified date Apr 5, 2020 6:07 AM