Excel Function

WEEKDAY

Returns day-of-week number.

WEEKDAY(serial_number, [return_type])

Arguments

serial_number

Required

Enter a date/reference-related value.

return_type

Optional

Weekday numbering system: 1/omitted = Sunday 1 to Saturday 7, 2 = Monday 1 to Sunday 7, 3 = Monday 0 to Sunday 6, 11-17 = Monday-to-Sunday start variants.

Practice Preview

Use WEEKDAY to return the result with these settings (Date cell: B2 (cell B2 (Start Date in column B)), Return type: 2 (Monday = 1)).

Example Table

#	ATask ID	BStart Date	CEnd Date	DNotes	EHoliday
2	T001	2026/03/01	2026/03/05	Standard task	2026/03/03
3	T002	2026/03/03	2026/03/10	Priority task	2026/03/06
4	T003	2026/03/05	2026/03/12	Standard task	2026/03/10
5	T004	2026/03/08	2026/03/14	Urgent task	2026/03/12
6
7
8

How to Use (Formula)

=WEEKDAY(B2, 2)

Result

Practice This Function

Start Function Practice Back to Function List

WEEKDAY FAQ

How do I use WEEKDAY in Excel?

Use WEEKDAY when you want to return the weekday number. Enter Date cell, Return type in that order, then add optional arguments when needed.

Where can I practice WEEKDAY?

Use the "Start Function Practice" button to jump straight into WEEKDAY drills.

What arguments does WEEKDAY use?

The main arguments are Date cell, Return type. Start with the required ones, then add optional arguments if needed.