Answer :

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.

Other Questions