Sort month/date/year data using month and date only

Hi "daddylonglegs",

Yes, I can see where this might become an issue and luckily I did not have
any of these dates in the system. However, I will also keep this version of
the recommended solutions on hand for future reference.

Thanks very much for your help.
SMW820

"daddylonglegs" wrote:

>
> Marcelo Wrote:
> > Hi,
> >
> > you could use an auxiliar column with =month(a1)&day(a1) copy it down
> > and
> > sort by this column
> >
> > HTH
> > Regards from Brazil
> > Marcelo
> >
> >
>
> I think you'd have a problem with this approach. 11th January and 1st
> november would both become 111.
>
> For a one column approach try
>
> =DATE(0,MONTH(A1),DAY(A1))
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=554245
>
>

I also realised I would need to do this. Fortunately I realised in time to set up a separate column for the year and another for the month and day. If I hadn't done this originally I suppose I would have done something like converting the date to a string and splitting it into the separate fields and and then sorting by the separate parts of the date. It would actually be simpler to split the date into the 3 component parts each in its own field.


Hope this helps or has someone found a better way?

Hi, it's been a while since I worked, and am rusty, our membership list has birthdays including year, all in one column, (I inherited it as it was and want to leave it easy if I can). I too would like to sort on Month and then Day, ignoring the year. But keep the year shown with birthday as it is relevant, I don't recall how to do what the top answers are doing. Is the one with the formula, the way I must format the column? I am confused. Sorry