Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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,097
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,097
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

Thread Tools
Display Modes


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 06:45 PM.


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