Can you create an additional date field "Mon, 27 Jan 2020" additional to "Monday, 27 January 2020"
The additional format date field would make my spreadsheet les cumbersome. I have Microsoft Office 365
Michael Daughety commented
Right click on cell, select Date from Category. Select one of the date formats. Then click on 'Custom' Category. In the Type field enter, with out quotes:
ddd, d mmm yyyy
click ok. Your cell should be formatted the way you wanted.