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.


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