Thread: check to see if a cell is blank if not populate adjacent cell wit.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default check to see if a cell is blank if not populate adjacent cell wit.
=IF(ISTEXT(A1),TODAY(),"")

You haven't said what you want to do if the cell contains a number (which is
not text and not blank).
If you want the current date for any entry (text or number), then try
=IF(A1<"",TODAY(),"")
--
David Biddulph

"Frusterated" wrote in message
...
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.


Reply With QuoteReply With Quote