View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tacrier Tacrier is offline
external usenet poster
 
Posts: 44
Default automatically show modified date?

When I save changes to my current worksheet, is it possible have a formula in
A2 to display today's date (based on the condition that changes were saved to
the current worksheet)?

A1 contents:
"Information on this worksheet was last updated on:"

A2: "today's date" (if in fact "today", changes were made and saved)

Thanks!! :)