WEEKDAY

Returns a number representing the day of the week for a given date.

Sample usage

WEEKDAY(Date)

Syntax

The following syntax returns a number between 0 and 6, starting from Sunday, that represents the day of the week.

WEEKDAY(date_expression )

The following syntax returns a number that represents the day of the week from a compatibility mode Date value.

WEEKDAY(X [,format_string ])

Parameters

  • date_expression - a Date & Time field or expression.
  • X - a field or expression that evaluates to Text, Number, or compatibility mode Date.
  • format_string - format forX. Optional ifX is correctly configured as a semantic date field.

Input format for compatibility mode dates

Supported date functions accept the following input formats ifX is a Text field or expression, or compatibility mode Date:

  • BASIC: %Y/%m/%d-%H:%M:%S
  • DEFAULT_DASH: %Y-%m-%d [%H:%M:%S]
  • DEFAULT_SLASH: %Y/%m/%d [%H:%M:%S]
  • DEFAULT_DECIMAL: %Y%m%d [%H:%M:%S]
  • RFC_1123: for example, Sat, 24 May 2008 20:09:47 GMT
  • RFC_3339: for example, 2008-05-24T20:09:47Z
  • DECIMAL_DATE: same asDEFAULT_DECIMAL

Any validstrptime format is accepted.

Supported time functions accept the following input format ifX is a Number field or expression:

  • SECONDS: seconds since Epoch
  • MILLIS: milliseconds since Epoch
  • MICROS: microseconds since Epoch
  • NANOS: nanoseconds since Epoch
  • JULIAN_DATE: days since Epoch

Examples

Example formulaInputOutput
WEEKDAY(Date) Jan 1, 2019 2
WEEKDAY(Date as Text, 'BASIC') 2019/01/01-09:40:45 2
WEEKDAY(Date as Number, 'SECONDS') 1561784874 6

WEEKDAY(Date as lots of Numbers, 'MILLIS')

 1562004058620 1

Notes

This function works with both compatibility mode dates andupgraded Date and Date & Time data types.

The following table describes the possible output of this function:

Number Day
0 Sunday
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday

Related resources

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026-02-19 UTC.