Last Updated formula

**Mark D Flanagan** · 08-23-2012, 05:20 AM

Hi,
I'm creating a spreadsheet which I have one cell that puts todays date in '=Today()', however I also want to put in a date when the spreadsheet / cells was last updated.

I was wondering is there is a formula that could autopopulate a date depending on the file modification date so that when the file is saved, it updated the cell.

Another variation I'm looking for is if we can identify when a cell was modified (I know this can be done on a shared file). I could then run conditional flags to highlight if the cell had not been updated in the last 7 days.

Please accept my appreciation in advance if you have the knowledge to resolve my strange query.

Thanks & Regards
Mark

**kvsrinivasamurthy** · 08-23-2012, 06:06 AM

pl see attached file.

**Mark D Flanagan** · 08-23-2012, 09:05 AM

Originally Posted by kvsrinivasamurthy

pl see attached file.

This perfectly does what I want it to.
Now to understand Workbook and Worksheet events so I can decipher how you did it lol

Many thanks

P.S.Is it an easy step by step process on how to do this.
i want column H to update on each row ;o)

**kvsrinivasamurthy** · 08-24-2012, 12:26 AM

Workbook and worksheet events are VB programmes that run on type of event selected.

If you want to for all cells in H column i have updated the file.
If you are satisfied mark the thread SOLVED.