Sorting Date fields

[Terr_Ol]

I Have date fields for wedding anniversaries and for birthdays. Is there an easy way to sort them into month order. We use this at church to acknowledge those having a birthday or wedding anniversary during the coming week.

[Justin_Barrett]

Welcome to the community, Terr! :grinning_face_with_big_eyes: One option is to add a formula field that extracts the month as a numeric value, then sort by that field. The formula can simply be:

MONTH({Date Field})

[Terr_Ol]

Thanks Justin, that did the trick. I changed date format to friendly and hid formula field. Still getting to grips with Airtable. The little grey cells get a bit slower when you get into your 70s.