WEEKDAY
Date

Converts a serial number to a day of the week

Syntax:

=WEEKDAY(serial_number, [return_type])

Example:

=WEEKDAY("1/1/2023")