View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Lapin Daniel Lapin is offline
external usenet poster
 
Posts: 1
Default Adding today's date if certain conditions apply

I am trying to add the current date when a particular cell is used for data.
The date needs to populate in another cell, and remain unchanged as long as
the other cell has data. How do I do it? I have tried an if-then statement
using today(), but I obviously didn't write it correctly.

Thanks!