Microsoft Office Forums IF Formula to calculate dates
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-21-2014, 02:13 PM
 Sophie1 Windows 7 64bit Office 2010 64bit Novice Join Date: Apr 2014 Location: United States Posts: 2
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
04-22-2014, 12:12 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,398

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
__________________
Please note I am not active on this forum anymore
#3
04-23-2014, 07:19 AM
 Sophie1 Windows 7 64bit Office 2010 64bit Novice Join Date: Apr 2014 Location: United States Posts: 2

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)

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Rockitman31 Excel 9 09-07-2015 09:41 AM funkyfido Excel 2 06-25-2013 04:25 PM USAOz Excel 2 09-11-2011 04:58 PM grs Excel 3 02-21-2011 02:17 AM rkeles Excel 4 09-22-2010 12:38 AM

All times are GMT -7. The time now is 12:55 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top