Enter TODAY if cell has data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
try
=IF(E5<>"",TEXT(TODAY(),"mm/dd/yy"),"")

--
Don Guillett
SalesAid Software
(e-mail address removed)
Cie said:
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
Click to expand...
it
 
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!
 
It won't stamp the date since the date will update every time the sheet is
calculated

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Not sure of formula help please 4
Using data between date range 0
Excel How to get the number of days an item was opened from the today's date. 14
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Access Property sheet data missing also syntax 0
If cell is blank automatically enter today's date in the same cell 21
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top