excel : format dates so that they include the day of the week in full letters

Question

In excel 2007, how can I format my dates so that they include the day of the week in full letters ? I've tried typing around but I just can't guess it.

Answer 1

Try using dddd for the day part of your format string e.g. dddd MMMM MM yyyy will give Wednesday December 14 2011

Answer 2

For UK/non-US date format users the following may help:-

dddd dd mmmm yyyy

which gives a date format of Friday 18 April 2014