I have a worksheet where I entered the date format as Date and format Aug-06.
However, when I enter a date that should be say Aug-05 the date always comes
up as Aug-06. Could anyone tell me why this is happening.

I am using Excel 2003.

Thanks in advance for your help.

Regards,

Dee