Show dates as days of the week

In Microsoft Excel

=TEXT(A2, "dddd")
Calculates the day of the week for the date and returns the full name of the day of the week (Monday)

=TEXT(A3, "ddd")
Calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu)

https://support.microsoft.com/en-us/office/show-dates-as-days-of-the-week-14f02f1d-8e3d-45a5-bdf8-3d962bf15327#:~:text=Format%20cells%20to%20show%20dates%20as%20the%20day%20of%20the%20week&text=Under%20Category%2C%20click%20Custom%2C%20and,Wed%2C%20and%20so%20on).