Thread: sort by date
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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