I have 2 columns of dates and I'm trying to use the IF formula to return a date meeting different criterias in a 3rd column.
For instance
In column A I have a date of 2/6/14
In column B I have a date of 4/12/14
In column C I am trying to get the following result using an IF statement (I believe this would be the right formula to use?).
If the date in column B is < 90 days from the date in column A I want to return the date that appears in column B in column C.
If the date in column B is > 90 days from the date in column A, I want to return the date that appears in column A + 90 days in column C.
Appreciate any assistance that someone might be able to provide.