sort by date
 

I am trying to sort by date where formatting is 'yyyymmdd'
and the months are December, January, February, and March.
The months need to show in the above order.

Thanks for helping with this..

Create a helper column with a ranking as you see fit such as
=IF(MONTH(G1)+1=13,1,MONTH(G1)+1) and sort by the helper column.

--
HTH

Bob Phillips

"Red" wrote in message
...
I am trying to sort by date where formatting is 'yyyymmdd'
and the months are December, January, February, and March.
The months need to show in the above order.

Thanks for helping with this..