Home |
Search |
Today's Posts |
#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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
format cell data to display stacked data | Excel Discussion (Misc queries) | |||
How to change cell data from all upper to title case | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Dragging cell data | Excel Discussion (Misc queries) |