View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bobito Bobito is offline
external usenet poster
 
Posts: 2
Default Recording and saving dates in Excel

I use the formula =if(<cell_ref="X";=today();"") to determine when a report
was changed. However, every time I open the file, the formula always returns
todays date (naturally !!).
How do I record and save as a fixed entry the date the <cell_ref was changed?