Enter TODAY if cell has data

[Guest]

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

 

[Don Guillett]

try
=IF(E5<>"",TEXT(TODAY(),"mm/dd/yy"),"")

--
Don Guillett
SalesAid Software
(e-mail address removed)

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

 

[Guest]

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!

 

[Guest]

=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

 

[Don Guillett]

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

 

[Peo Sjoblom]

It won't stamp the date since the date will update every time the sheet is
calculated

--
Regards,

Peo Sjoblom

(No private emails please)