Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2014, 02:13 PM
Sophie1 Sophie1 is offline IF Formula to calculate dates Windows 7 64bit IF Formula to calculate dates Office 2010 64bit
Novice
IF Formula to calculate dates
 
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
  #2  
Old 04-22-2014, 12:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline IF Formula to calculate dates Windows 7 64bit IF Formula to calculate dates Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 04-23-2014, 07:19 AM
Sophie1 Sophie1 is offline IF Formula to calculate dates Windows 7 64bit IF Formula to calculate dates Office 2010 64bit
Novice
IF Formula to calculate dates
 
Join Date: Apr 2014
Location: United States
Posts: 2
Sophie1 is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Formula to calculate dates 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
IF Formula to calculate dates 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

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft