Help with Dates!!!

  • Thread starter Thread starter Tammi
  • Start date Start date
T

Tammi

I am trying to sort a spreadsheet using only the month and
day in the date field. I do not want to use the year in
the sorting process. How can I do this? I have tried to
format the cell, copy and special past the cell and the
year keeps coming into the equation.

I have an urgent need to assistances so anything you can
do to help would be greatly appreciated!!
 
Tammi,

I think this might work, though it is a bit clumsy. Be sure to back up your
work prior to trying.

Insert a new column. It will be your date sorting column. This date
sorting column will be the correct month and day, but will use the current
year (any year is fine, since you are not using the year to sort.)

So, your formula for the new date Col is this:

=Date(year(2003), month(old_date_Col), day(month(old_date_Col))

Say your old data was in Col B

=Date(year(2003), month(b1), day(month(b1))

Sort your data on this new column.

Hope this helps.

Again, be sure to back up your work prior to trying.

Regards,
Kevin
 
Tammi,

You can use MONTH and DAY functions.

If dates are in column A, you can include the following
formulas:

B1:
=MONTH(A1)
C1:
=DAY(A1)

Drag down the formulas, copy and paste data as values and
use those columns to sort.

Regards,
Felipe
 
Felipe said:
Tammi,

You can use MONTH and DAY functions.

If dates are in column A, you can include the following
formulas:

B1:
=MONTH(A1)
C1:
=DAY(A1)

Drag down the formulas, copy and paste data as values and
use those columns to sort.
Click to expand...

.....and you can hide the columns way off the the right where they won't be
seen. Just remember they're there when you sort.
 
You could use this to sort by month, day date:

with your date in D3,
=MONTH(D3)*100+DAY(D3)
 
This help tremendously. Thanks.

Sorry I did not respond sooner, but this was a god send!!!
 
Back
Top