I want to show the day of the week (Monday, Tuesday etc) against a date in excel so in column A I have the dates in the format dd/mm/yyyy and in column B the formula =(TEXT(DAY(A1),"dddd") but I seem to get errors. For instance 29/02/2004 and 01/03/2004 both come up as "Sunday"! Then 30/11/2004 through 02/12/2004 produces "Sunday", "Monday", "Sunday"! This happens on both Office 2000, Office XP and Office 2003 (all running on Windows XP professional) on several different PCs but all with regional settings set to UK

Has anyone else come across this problem? And has anyone come across a solution?