#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Hi and welcome
Perhaps =IF(B1<A1+90,B1,A1+90) PS it's always best to indicate your location especially when you have questions about dates. Regional settings can be quite different and also the provided solutions
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thank you so much. Your suggestion worked. I just made one change as it was having difficulties with the dates. What I ended up doing was.
=IF(DATEVALUE(P3)<J3+90,P3,J3+90) |
|
Similar Threads | ||||
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 |
What formula should I use to calculate commission? | grs | Excel | 3 | 02-21-2011 02:17 AM |
Calculate formula base of list menu | rkeles | Excel | 4 | 09-22-2010 12:38 AM |