Excel dates normally include a year, even if it not displayed by reason of
formatting. you can always enter:

'jan 21

note the single quote. I don't know what you would accomplish by doing
this, since it would be just text to Excel, not a date.
--
Gary's Student
gsnu200702


"kmkx70a" wrote:

I would like to enter dates with just the month and day. When I do, Excel
automatically enters the year also. this really messes up sorting. I want to
enter the date with out the year showing up. I format the cells with mmm/dd
but that doesn't help.
Any help would be appreciated. Harry