WEEKDAY
Date

Returns the day of the week corresponding to a date

Syntax:

=WEEKDAY(serial_number, [return_type])

Example:

=WEEKDAY("1/1/2023")