If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Enter TODAY if cell has data
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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 |
#6
|
|||
|
|||
Enter TODAY if cell has data
The Following is a simple example of how to do this: =IF(C10,NOW(),"") The above formula will look for any info in Cell "C1" and if found Stamp the current Date in whatever Cell this Formula exists. hope This helps. -- Engineer_Bill ------------------------------------------------------------------------ Engineer_Bill's Profile: http://www.hightechtalks.com/m570 View this thread: http://www.hightechtalks.com/t945742 |
#7
|
|||
|
|||
Enter TODAY if cell has data
It won't stamp the date since the date will update every time the sheet is
calculated -- Regards, Peo Sjoblom (No private emails please) "Engineer_Bill" wrote in message ... The Following is a simple example of how to do this: =IF(C10,NOW(),"") The above formula will look for any info in Cell "C1" and if found Stamp the current Date in whatever Cell this Formula exists. hope This helps. -- Engineer_Bill ------------------------------------------------------------------------ Engineer_Bill's Profile: http://www.hightechtalks.com/m570 View this thread: http://www.hightechtalks.com/t945742 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rapid input Via datasheet | RudyR_Seattle | General Discussion | 4 | January 31st, 2005 01:33 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Cell reference data not displaying in chart | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 06:30 PM |
Cell Data | Clay | Worksheet Functions | 4 | October 16th, 2003 11:40 AM |