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

DAYOFWEEK

Calculates the day of the week (1-7) for a specified date where the week starts on Monday.

Syntax

=DAYOFWEEK(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

=DAYOFWEEK(DATE(2020, 2, 3, 4, 5))1
Feb 3, 2020 4:05 AM is a Monday

=DAYOFWEEK(DATE(2020, 3, 4, 5, 6))3
Mar 4, 2020 5:06 AM is a Wednesday