another way
=IF(AND(NOT(ISTEXT(E2)),E2=0),NOW(),"?")

"joe" wrote:

Can someone give me an example of a formula that will look at the contents of
one cell, and if that cell is = 0 then another cell will display todays date
and time.