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
@Jazyk did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!