Inserting Dates without years, please help!!

E

Erich

Someone please help!!!

I cannot for the life of me figure out how to insert dates in any format
where the year will not automatically attach itself. Im making a database of
historical data and only the Month and day is important, I don't want the
year. I need to be able to sort it by month and day regardless of what year
it was, the only thing I could do was enter Aug.15 for example (with period
in between Aug and 15) but then it sorted alphabetically

can anyone help?

thanks so much

Erich
 
M

Mike H

Hi,

I wouldn't go down the road of having text as dates with no years. Instead
insert 'normal' dates and use a custom format of dd mmmm

To sort add a helper column with a formula of =TEXT(A1,"mmdd") copy down, sort
all columns by the helper column.

Note that this helper column can be hidden.

Mike
 
G

Gord Dibben

Enter dates in column A.

In B2 enter =MONTH(A2)

In C2 enter =DAY(A2)

Copy down then sort on month then by day.


Gord Dibben MS Excel MVP
 
Top