WEEKDAY

Returns the number that corresponds to the week of provided date.

Syntax

WEEKDAY(date, [return_type])

Arguments

Argument	Description	Required
`date`	A date within the week	Required
`return_type`	A number that determines which day is considered the first day of the week. Defaults to 1.	Optional

Examples

Get weekday for specific date (Sunday = 1)

=WEEKDAY(A1)

Result ⇒ 2

	A
1	2024-01-15

Get weekday with Monday as first day

=WEEKDAY(A1, 2)

Result ⇒ 1

	A
1	2024-01-15

Check if date is weekend

=OR(WEEKDAY(A1)=1, WEEKDAY(A1)=7)

Result ⇒ true

	A
1	2024-01-14

Related Functions

Other Date/Time functions:

DATE - Constructs a date from year, month, and day values.
DATEDIF - Calculates the number of days, months, or years between two dates
DATEONLY - Extracts the date component from a datetime value, removing the time portion. The result is in workbook time zone.
DAY - Returns the day of the month from a date value.
DAYOFWEEK - Returns the day of the week as a text string
DAYS - Returns the number of days between two dates
EDATE - Returns a date on the same day of the month, n months in the past or future.
EOMONTH - Returns last day of a month as a serial number after adding a specified number of months before or after another date.
HOUR - Returns the hour component of a specific time as a number between 0-23.
ISOWEEKNUM - Returns the ISO-8601 week number (1–53) of the year for a given date.
MINUTE - Returns the minutes of a time value
MONTH - Returns the month from a date value (1-12).
NETWORKDAYS - Returns the number of work days between two dates, excluding saturday and sunday.
NOW - Returns the current date and time as a date value in UTC.
SECOND - Returns the seconds of a time value
TIME - Returns the created time with individual hour, minute and second components.
TIMEVALUE - Returns the decimal number of the time represented by a string. The decimal number is a value ranging from 0 (inclusive) to 1 (exclusive).
TODAY - Returns the current date as a date value in UTC with time stripped.
WEEKNUM - Returns the week number of a specific date
WORKDAY - Returns the date that is the specified number of working days before or after the start date.
YEAR - Returns the year from a date value.
YEARFRAC - Calculates the fraction of the year represented by the number of whole days between two dates

← Back to Formula Reference