Display days of the week in Excel Online


I have started using Excel Online mainly because it is free and meeting new challenges because a good deal of the useful functionality has been taken out of the online product. I was making a calendar for the next month recently and wanted to display the date in the first column and format it in the long date format -

Friday 24th July 2015.

I ended up with the date displayed as 24 July 2015 in the first column then the second column calculates the weekday number =WEEKDAY(A1) then the third column displays the day of the week like this.

=IF(B1=1,"Sunday",IF(B1=2,"Monday",IF(B1=3,"Tuesday",IF(B1=4,"Wednesday",
IF(B1=5,"Thursday",IF(B1=6,"Friday",IF(B1=7,"Saturday","Error")))))))

Tags - Excel Online, calendar, monthly, Microsoft Excel, day of the week, weekday, long date