![]() |
#1
|
|||
|
|||
![]()
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. ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
Formula to calculate Date and Time | funkyfido | Excel | 2 | 06-25-2013 04:25 PM |
Formula to calculate Leap Year | USAOz | Excel | 2 | 09-11-2011 04:58 PM |
![]() |
grs | Excel | 3 | 02-21-2011 02:17 AM |
Calculate formula base of list menu | rkeles | Excel | 4 | 09-22-2010 12:38 AM |