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
|