|
|
#1
01-17-2016, 05:38 PM
|
|||
|
|||
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 
|
| Tags |
| dateif |
|
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode