If you type in a date in Excel, it will not by default include the day of the week.
To format it to include the day of week, from the Home tab, in the Number group, click the dialog box launcher to open the Format cells dialog box with the Number tab uppermost.
From the Category list, click Custom. In the Type box, type in dddd dd mmm yyyy.
A date that you originally type in with the format 31/10/2013 will now read Thursday 31 Oct 2013.
Find out more about our Excel training courses Sydney, Australia.