Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page DATE IF formulas
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2016, 05:38 PM
ConfuddledOne ConfuddledOne is offline DATE IF formulas Windows 7 64bit DATE IF formulas Office 2007
Novice
DATE IF formulas 		 
Join Date: Oct 2014
Posts: 10
ConfuddledOne is on a distinguished road
Question DATE IF formulas
I'm needing some assistance with a DATEIF formula - I want to return one of two text depending on the date of a cell



If I3 is greater than todays date J3 = 'suspended', if I3 = equal to or less than todays date J3 = 'review'

In addition to this, if I3 is blank, J3 = 'review'

I know it is something really stupid that I'm missing, but I just cant get it to work
Reply With Quote
  #2  
Old 01-17-2016, 11:06 PM
xor xor is offline DATE IF formulas Windows 10 DATE IF formulas Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,102
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Date If
=IF(I3>TODAY(),"suspended",IF((I3>0),"review",""))
Reply With Quote
  #3  
Old 01-18-2016, 01:49 PM
ConfuddledOne ConfuddledOne is offline DATE IF formulas Windows 7 64bit DATE IF formulas Office 2007
Novice
DATE IF formulas 		 
Join Date: Oct 2014
Posts: 10
ConfuddledOne is on a distinguished road
Default
That works well, except if I3 is blank - it returns a blank in J3, not 'review'
Reply With Quote
  #4  
Old 01-18-2016, 11:00 PM
xor xor is offline DATE IF formulas Windows 10 DATE IF formulas Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,102
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Date If
=IF(I3>TODAY(),"suspended",IF(((I3>0)+(I3="")),"re view",""))
Reply With Quote
  #5  
Old 01-19-2016, 02:20 PM
ConfuddledOne ConfuddledOne is offline DATE IF formulas Windows 7 64bit DATE IF formulas Office 2007
Novice
DATE IF formulas 		 
Join Date: Oct 2014
Posts: 10
ConfuddledOne is on a distinguished road
Default
Gave me an error message to start with, but seems to be working great now

Thank you
Reply With Quote
Reply

Tags
dateif

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
DATE IF formulas How can a document have the same date modified/create date, yes have have actual file content? legaleagle Word 15 01-07-2015 06:58 PM
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM
Time & Date Formulas in Graphs Ady_E Excel 5 11-15-2012 05:29 AM
DATE IF formulas Meaning of current date vs status date when saving baselines ketanco Project 1 02-08-2012 02:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:40 PM.

Contact Us - Privacy Statement - Top

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