FUNCTION CATALOGUE / DATE & TIME
WEEKDAY Excel function
Returns the day-of-week number.
Correct sentence to use
Return the weekday number for [date].
Modify this query in PlainFormula →Example formula
=WEEKDAY(A2,2)
Returns a weekday number.
Syntax
WEEKDAY(serial_number, [return_type])
Argument signature: serial_number, [return_type]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.