Thanks for your replies, im just a bit confused, how does those
forulae work exactly?

I have my dates in Column X7:X100

I have a 'January' column starting at A5. I want to display all the
January dates in X7:X100 in a list starting at A5, all the feburary
dates in a list starting at B5 etc etc .

Could you explain your answer in a bit more detail?

Thanks a lot