WEEKDAY
Returns the day of the week corresponding to a date. The day is given as an integer
Syntax
WEEKDAY(serial_number, [return_type])
Parameters
- serial_number: Required. A sequential number that represents the date of the day you are trying to find
- return_type: Optional. A number that determines the type of return value (1=Sunday=1, 2=Monday=1, 3=Monday=0)
Example
=WEEKDAY("1/15/2024", 2)