• Welcome to Overclockers Forums! Join us to reply in threads, receive reduced ads, and to customize your site experience!

Excel help

Overclockers is supported by our readers. When you click a link to make a purchase, we may earn a commission. Learn More.

DavidJa

Member
Joined
Feb 11, 2006
Location
Folding&home
is there a way to sort 1 column worth of daily data into months per year?
basically i have 1 column of 5 years worth of daily data that i want to convert into months for each of the years.
 
You can use the MID function to pull out parts of a string, so maybe you could use that to pull out the month and then sort by that.
 
Back