=IF(TRIM(E5)<"",etc..

Note that the formula will update with tomorrow's date tomorrow, if you want
a date stamp that will stay you might want to look at this

http://www.mcgimpsey.com/excel/timestamp.html


Regards,

Peo Sjoblom

"Cie" wrote:

Thanks! That WORKED! But, you knew it would!
I'd like to ask one other question, concerning this formula. What can I
enter to exclude a single SPACE as being seen as TEXT in this formula?

Thanks again!

"Don Guillett" wrote:

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