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

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

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

ArgumentRequired?What it does
serial_numberYesThe date.
return_typeOptional1 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)
ABC
1DateWEEKDAYDay
23/15/20261Sunday
33/16/20262Monday
43/21/20267Saturday
=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")
AB
1Shift dateType
23/13/2026Weekday
33/14/2026Weekend
43/15/2026Weekend
53/16/2026Weekday
=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.
Kyle Stott

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.