DAY_OF_WEEK

Determines the day of the week for a given date or datetime, where Monday is 1, Tuesday is 2, and so on

Updated over a week ago

Description

The DAY_OF_WEEK() function calculates and returns the day of the week for a given date or datetime, with Monday represented as 1, Tuesday as 2, and so forth. This is useful for scheduling, date-related analytics, or organizing data by weekdays.

Syntax

DAY_OF_WEEK(date)

Output

integer

Variables

  1. date: The date or datetime for which you want to determine the day of the week.

Example

DAY_OF_WEEK(`Appointment Date`)

Appointment

Appointment Date

DAY_OF_WEEK

Meeting A

August 27, 2023

7

Meeting B

August 28, 2023

1

Meeting C

August 29, 2023

2

Meeting E

August 30, 2023

3

Meeting F

August 31, 2023

4

Meeting G

September 1, 2023

5

Meeting H

September 2, 2023

6

Did this answer your question?