WEEKDAY

May 09, 2023

Syntax

WEEKDAY(<date>)

Description

Returns an integer between (1-7) corresponding to the day of the week of the date.

Day	Integer

Day	Integer
Monday	1
Tuesday	2
Wednesday	3
Thursday	4
Friday	5
Saturday	6
Sunday	7

Examples

Date	WEEKDAY returns

Date	WEEKDAY returns
Oct 15, 2002	2
Oct 16, 2002	3
Oct 17, 2002	4
Oct 18, 2002	5
Oct 18, 2003	6
Oct 18, 2004	1
Oct 18, 2030	5