trying to write a formula with a date range

[Jazyk]

Hello I have two sets of dates (Sale Date and Redemptions Date) .  I am trying to write a formula that shows if Redemption date is more than 6 months of sale date than it outputs "over 6 months" or if over 1 year then out puts "over 1 year"... ie

Sale Date  Redemption Date    Output

6/30/2022     1/30/2023            Over 6 Months

6/30/2022      8/15/2023            Over 1 year

6/30/2022      10/30/2022           Under 6 months    

[caltang]

@Jazyk like so:

[caltang]

@Jazyk did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!