Inserting Dates without years, please help!!
 

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

Inserting Dates without years, please help!!
 

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

"Erich" wrote:

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

Inserting Dates without years, please help!!
 

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

On Thu, 19 Jun 2008 22:34:01 -0700, Erich
wrote:

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