View Single Post
  #3   Report Post  
Cie
 
Posts: n/a
Default

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