I see Peo answered your other question. Glad to help.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
try
=IF(E5<"",TEXT(TODAY(),"mm/dd/yy"),"")

--
Don Guillett
SalesAid Software

"Cie" wrote in message
...
I would like to know how to enter a formula that will enter TODAY's DATE
in
one cell if another cell has data (any kind of data but, mostly text) in
it