Formula Help
That did it thank you so very much.
--
Regards
Michael Koerner
wrote in message
ups.com...
Michael:
=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))),"")
Alan
Michael Koerner wrote:
Thanks to Will Cairns who provide me with the following formula.
=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))))
The way it works now, if the text value does not equal "yyyy" the word
"FALSE" is inserted into the cell. Is there a way to change it so that
the
cell is left blank if the value of T25 is also blank?
--
Regards
Michael Koerner
|