I'm not very good at this and am struggling to find the correct formula to calculate future dates but with multiple variables and cells as conditions... I need to provide the information tomorrow! Please can someone help?
Column M contains dates certain activities were carried out
Column N contains text related to the results (neg, pos, or an actual number)
Column AP needs to contain a new date either 3 , 6, or 12 months in the future based on the text contained in N
If N is "neg" add 12 months
If N is "pos" or a any number other than "<1.5E+1", add 6 months
If N is "<1.5E+1" add 6 or 12 months - ideally being able to choose between the 2 dates, otherwise leave as 6 months).
I am soooo grateful for any help possible!