I'm trying to set an if/or formula. Basically I want it to look at a field, if it contains xx apply the formula to add 10 years to the date in the next field, if the field contains xxx then apply the formula to add 6 years. Below is the formula I've been trying to use. It seems to only recognize the 10 year formula and ignores the second.
=IF(OR(J6="xx",J6="xxx"),(DATE((YEAR(K6)+10),MONTH(K6),DAY(K6))),(DATE((YEAR(K6)+6),MONTH(K6),DAY(K6))))
Solved by M. H. in 22 mins