Thread: check to see if a cell is blank if not populate adjacent cell wit.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default check to see if a cell is blank if not populate adjacent cell wit.
Maybe:

=if(a1="","",today())

Be aware that this formula will change when you open the workbook on a different
date (and the workbook recalcs).

If you want to keep track of when the data changed, maybe using J.E. McGimpsey's
worksheet event macro:
http://www.mcgimpsey.com/excel/timestamp.html

Frusterated wrote:

Hello need help with a formuala. In a spreadsheet I want to check and see
iif a cell contains text, if so, I want to populate an adjacent cell with the
current date. If the cell is blank I dont want to do anything... Thanks.

--

Dave Peterson
Reply With QuoteReply With Quote