Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.. |
#2
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |