View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Updating a DATE, only if the page has been modified.

I have a spreadsheet with a cell containing:
="Print Date: "&Text(TODAY(),"mmm-dd-yyyy")

I want to add another cell that reflects the date of the last time the sheet
was modified/changed.

So the logic would be somthing like:
IF (Sheet-Changed, Current-Date, Previous-Date)

Can any one point me in the right direction?

Thank you