#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Date If
=IF(I3>TODAY(),"suspended",IF((I3>0),"review",""))
|
#3
|
|||
|
|||
That works well, except if I3 is blank - it returns a blank in J3, not 'review'
|
#4
|
|||
|
|||
Date If
=IF(I3>TODAY(),"suspended",IF(((I3>0)+(I3="")),"re view",""))
|
#5
|
|||
|
|||
Gave me an error message to start with, but seems to be working great now
Thank you |
Tags |
dateif |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Meaning of current date vs status date when saving baselines | ketanco | Project | 1 | 02-08-2012 02:20 PM |