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
|