View Single Post
 
Old 04-21-2014, 02:13 PM
Sophie1 Sophie1 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2014
Location: United States
Posts: 2
Sophie1 is on a distinguished road
Default IF Formula to calculate dates

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.
Reply With Quote