sort by date

R

Red

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..
 
B

Bob Phillips

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.
 
Top