WEEKDAY

Date & timeExcel 2007

The day of the week of a date, as a number.

Syntax

WEEKDAY(serial_number, [return_type])

Arguments

serial_number: The date.
return_typeoptional: 1 (default) Sun=1…Sat=7; 2 Mon=1…Sun=7; 3 Mon=0…Sun=6.

Examples

=WEEKDAY(A2, 2)>5

→ TRUE on weekends (Mon-start)

Related functions

WORKDAY NETWORKDAYS CHOOSE

More Date & time functions

DATE DATEDIF DATESTRING DATEVALUE DAY DAYS DAYS360 EDATE EOMONTH HOUR ISOWEEKNUM MINUTE

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.