sorting date's by date number

[KevinThomas]

I am trying to calculate when specific events occur during the time of the month. Is there a way of obtaining an “absolute” date value to enable a sort by month date.

For instance if I wanted to sort:

02/02/09
05/02/09
01/04/09
23/04/09
11/05/09

By date (ie earliest in the month) I would want the result to be,

01/04/09
02/02/09
05/02/09
11/05/09
23/04/09

Is this possible, and if so how?

Many Thanks

[darkyam]

In a helper column, =Day(A1) and copy down, then sort by the helper column and delete it.

[MickG]

Hi, Try this:- Results start "B1".

Please Login or Register  to view this content.

Regards Mick