Sort by specific day of week

[xeven_]

Using office 365 excel, I need to sort/group a long column of dates by all the mondays, tuesdays etc.... I am trying to see which days equal the most/least returns. Is there a formula that can help me do this?

 

[Peter_SSs]

Using office 365

Please put that information in your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I think your requirement would be clearer if you could also give us the sample data and the expected results with XL2BB