Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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
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 07:33 PM.


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