Calculating Yes/No if a date is within the past 3 months

[SophieRawcliffe]

Hi, I have a long list of dates and I want to calculate in a new column whether a date falls within the last 3 months, 3-6 months, and 6-12 months. Any help?  

Example output below

Transaction ID	Date	0-3 MONTHS	3-6 MONTHS	6-12 MONTHS
1	10/05/2024	No	Yes	No
2	10/08/2024	Yes	No	No
3	01/01/2022	No	No	No

[aatalai]

@SophieRawcliffe try these formrulas

Also attached workflow for reference

[binuacs]

@SophieRawcliffe one way of doing this