Find out on what day a date falls on in Excel

You can simply use Text formula to find out on what day a date falls on.

=TEXT(A1,"dddd") or =TEXT(A1,"ddd")