WEEKDAY Function
Returns the day of the week as a number.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A number for the day of the week
Overview
WEEKDAY tells you which day of the week a date falls on. By default Sunday is 1 and Saturday is 7.
Change return_type to start the week on Monday — 2 makes Monday 1 and Sunday 7, which makes "is it a weekend?" a simple >5 test.
Syntax
=WEEKDAY(serial_number, [return_type])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | The date. |
| return_type | Optional | 1 or omitted: Sun=1 … Sat=7. 2: Mon=1 … Sun=7. 3: Mon=0 … Sun=6. 11–17: Monday to Sunday as day 1. |
Examples
Example 1 — Default numbering (Sunday = 1)
March 15, 2026 is a Sunday.
B2fx=WEEKDAY(A2)
| A | B | C | |
|---|---|---|---|
| 1 | Date | WEEKDAY | Day |
| 2 | 3/15/2026 | 1 | Sunday |
| 3 | 3/16/2026 | 2 | Monday |
| 4 | 3/21/2026 | 7 | Saturday |
=WEEKDAY(A2) Explain
Example 2 — Weekday or weekend?
With return_type 2, Saturday is 6 and Sunday is 7.
B2fx=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")
| A | B | |
|---|---|---|
| 1 | Shift date | Type |
| 2 | 3/13/2026 | Weekday |
| 3 | 3/14/2026 | Weekend |
| 4 | 3/15/2026 | Weekend |
| 5 | 3/16/2026 | Weekday |
=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday") Explain
Common mistakes
- Off-by-one surprises. Different return types number the days differently. Note which one you used, or show the day name with =TEXT(A2,"dddd").
Notes
- Highlight weekends with Conditional Formatting › New Rule › Use a formula: =WEEKDAY($A2,2)>5.
- Related functions: WEEKNUM, WORKDAY, NETWORKDAYS, TEXT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.