default year

[Mic]

I have a list of dates (mm/dd) in a column. I have formated the cells to
display mm/dd and this works, however, if you double click on the date it
displays the year. I added most of these different dates in 2007 and I am
now entering more. When I sort them by date, the ones I recently entered
(2008) are at the bottom when what I want is them mixed in with the others.
How do I get it to NOT acknowlegde the year?

 

[Dave Peterson]

To be a date, you need to include the month, day and year.

You could enter info that isn't a real date by either:
Preformatting the cell as Text, then type the mm/dd
or
start your entry with an apostrophe: 'mm/dd

Or if you already have the dates and don't care about the year, you could select
the range and change all the 2007's to 2008 (via edit|replace).

Or if you want the data to retain the year, you could use a helper column that
contains a formula that ignores the year:

=text(a2,"mm/dd")
drag down
and sort by this column.