WEEKDAY function in Excel

WEEKDAY returns the day of the week as a number (2 = Monday is 1).

Syntax

=WEEKDAY(serial_number, [return_type])

Argument	Required?	What it is
serial_number	Required	The date to take the part from.
return_type	Optional	1 (default) numbers Sunday as 1; 2 numbers Monday as 1.

Type the formula yourself and get it graded instantly, no Excel needed.

WEEKDAY returns the day of the week as a number (2 = Monday is 1).

=WEEKDAY(serial_number, [return_type])

Argument	Required?	What it is
serial_number	Required	The date to take the part from.
return_type	Optional	1 (default) numbers Sunday as 1; 2 numbers Monday as 1.

Type the formula yourself and get it graded instantly, no Excel needed.