Spreadsheet formulas explained, side by side

WEEKDAY Function in Excel, Google Sheets, Airtable & Notion

WEEKDAY tells you which day of the week a date falls on, as a number. Which number means Monday depends on the return type — and on the app.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inWEEKDAY(serial_number, [return_type])
Also accepts return types 11–17 (week starting Monday…Sunday, numbered from 1).
Google Sheets✔ Built inWEEKDAY(date, [type])
Types 1, 2 and 3 only.
Airtable✔ Built inWEEKDAY(date, [startDayOfWeek])
Returns 0–6 with 0 = Sunday. The copy-ready formula converts this to the Excel numbering you picked.
Notion✔ Built inday(date)
Returns 1–7 with 1 = Monday … 7 = Sunday, which equals Excel type 2.
Try WEEKDAY with your own values
Result (as Excel & Google Sheets return it)
6
Your formula, ready to paste
Excel=WEEKDAY(DATE(2024, 3, 15)) open excel.new ↗
Google Sheets=WEEKDAY(DATE(2024, 3, 15)) open sheets.new ↗
AirtableWEEKDAY(DATETIME_PARSE("2024-03-15", "YYYY-MM-DD")) + 1
Notionmod(day(parseDate("2024-03-15")), 7) + 1

Arguments

ArgumentWhat it means
dateThe date to check.
[return_type] optional1 (default): Sunday = 1 … Saturday = 7. 2: Monday = 1 … Sunday = 7. 3: Monday = 0 … Sunday = 6.

Examples

FormulaResultWhyCopy
=WEEKDAY(DATE(2024, 3, 15))615 March 2024 is a Friday; type 1 counts Sunday as 1.
=WEEKDAY(DATE(2024, 3, 15), 2)5Type 2 counts Monday as 1, so Friday is 5.
=WEEKDAY(DATE(2024, 3, 17), 3)6Sunday with type 3 (Monday = 0).
=WEEKDAY(A2, 2) > 5TRUE on weekendsWith type 2, Saturday and Sunday are 6 and 7.

Examples use Excel / Google Sheets syntax unless noted.

How WEEKDAY works

Every app numbers the week differently, so check the numbering before you compare against a constant. Excel and Google Sheets default to type 1 (Sunday = 1), which is the US convention; most of the world thinks of Monday as day 1, which is type 2. Type 2 makes weekend tests simple: =WEEKDAY(A2, 2) > 5 is TRUE on Saturday and Sunday.

Airtable's WEEKDAY() is zero-based: Sunday = 0 through Saturday = 6, so add 1 to match Excel's default. Its optional second argument "Monday" makes the week start on Monday (still counting from 0). Notion's day() uses the ISO numbering, Monday = 1 through Sunday = 7, the same as Excel type 2. The copy-ready formulas on this page convert each app to the return type you choose.

If you want the weekday as a word, formatting is easier than WEEKDAY: =TEXT(A2, "dddd") gives “Friday” and "ddd" gives “Fri”. To count or skip working days use NETWORKDAYS and WORKDAY rather than testing each date.

Frequently Asked Questions

How do I check if a date is a weekend?
Use =WEEKDAY(A2, 2) > 5. In Airtable: OR(WEEKDAY({Date}) = 0, WEEKDAY({Date}) = 6). In Notion: day(prop("Date")) > 5.
Why is my WEEKDAY one off between apps?
Excel type 1 starts at Sunday = 1, Airtable at Sunday = 0 and Notion at Monday = 1. Pick the conversion shown in the tester above.

Part of the Date & Time functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.