View Single Post
 
Old 01-17-2016, 05:38 PM
ConfuddledOne ConfuddledOne is offline Windows 7 64bit Office 2007
Novice
 
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