Basically I'm trying to add some checks to a table the gets updated on a regular basis.

The formulas for three of the cells contain dates:
=IFERROR(I14/ROUNDUP((("4/5/2014"-VLOOKUP($C$14,'Goals'!$A:$I,8,FALSE)) /(VLOOKUP($C$14,'Goals'!$A:$I,9,FALSE)-VLOOKUP($C$14,'Goals'!$A:$I,8,FALSE)))*VLOOKUP($C$ 14,'Goals'!$A:$I,2,FALSE),0),"")

as part of the check I'd like to compare today() with the string of text in the formula that is the date to make sure they've been updated.

I have a tab with all the validations and I've tried concatenating the formula cell with an ' to force it into a text value but that didn't work. Nor does trying to change it to a text value. Bahttext gave me some kind of hebrew text.

Any other options? I'd like it to be a formula not a VBA solution.

Thanks in advance.