Dates are wrong, is there an update?

**FrankMCook** · 03-05-2012, 07:02 PM

If I enter 02/06/2012 into a date field, it gives me Monday the 6th instead of Tuesday the 7th and all subsequent dates are wrong too. Excel seems to have forgotten about the leap year. Is there a patch?

**DGagnon** · 03-05-2012, 07:04 PM

the date 2/06/2012 is February 6th 2012, which was a Monday.. are you meaning to enter 03/06/2012?

**TMS** · 03-05-2012, 07:09 PM

What you've written doesn't make any sense.

02/06/2012 = 02 June 2012 = Saturday (UK Format dd/mm/yyyy)
02/06/2012 = February 06, 2012 = Monday (American Format mm/dd/yyyy)

Why would you expect to get Tuesday the 7th of anything out of that date?

Regards, TMS

**FrankMCook** · 03-05-2012, 07:16 PM

I'm an idiot. It is March now, isn't it. I was so convinced that I was seeing a leap year mistake that I overlooked that I'd entered a February date and expected March days of the week. changing the cell with 02/06 to 03/06 fixes everything.

**Peter59** · 03-06-2012, 09:34 AM

Hi, I have the same problem. I have been using excel 2002 without any problems. I just did a clean instal of XP home (may be unrelated) and now have this issue after reinstalling microsoft office pro. I have formatted the cell and selected date e.g. 14-Mar-01 and have location set to Australia. I type in a date e.g. 7/3 and get 3-Jul-12 when I want 7-Mar-12. I have also noticed that the sample box in the format cells remains blank. Any ideas?

**royUK** · 03-06-2012, 09:38 AM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.