Enter TODAY if cell has data

[Cie]

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

 

[Cie]

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!

 

[Peo Sjoblom]

=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.

 

[Engineer_Bill]

The Following is a simple example of how to do this:


=IF(C1>0,NOW(),"")



The above formula will look for any info in Cell "C1" and if foun
Stamp the current Date in whatever Cell this Formula exists.


hope This helps

 

[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)