Using an If Statement with Dates

[kayla_o]

Hello - I am seeking assistance on my use case below: 

In my data set:

I have one column "REDEMPTION MONTH" which represents the month that a customer redeemed a prize. (customer can have multiple redemption months)
I have another column "SURVEY MONTH" which represents the month that a customer took the survey. 

I want to capture all redemption months 3 months prior to the survey month. 

(i.e., in the dataset, if the SURVEY MONTH = 06/2022, I would ideally like to create a formula to flag all of the REDMEPTION MONTH rows that are within 04/2022, 05/2022, and 06/2022.

thanks!

[binuacs]

@kayla_o One way of doing this is by converting the month fields into dates then apply the filter