Answer:
The function WEEKDAY in excel takes a date and returns a number between 1 to 7 showing the day of week.
For instance, in an excel cell B1, this formula will automatically convert to day of the week,
=CHOOSE(WEEKDAY(B1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat"), and press the Enter key.
