Hello,
I'm just wondering if anyone know of a way for the date in a cell to automatically update to today's date only if a change has been made to any part of the spreadsheet?
In my spreadsheet, cell D4 is the 'Date of last update' - I would like this cell to change to today's date if any other part of the spreadsheet is changed. If I just open the doc but I don't make any changes, I would like the date to stay the same as it was previously.
I think from searching elsewhere this can be done with VBA but I have no experience in this area at all so I was hoping someone could show me a way this could be done just using formulas if possible.
Any help appreciated.
Many thanks, Warren.
I'm just wondering if anyone know of a way for the date in a cell to automatically update to today's date only if a change has been made to any part of the spreadsheet?
In my spreadsheet, cell D4 is the 'Date of last update' - I would like this cell to change to today's date if any other part of the spreadsheet is changed. If I just open the doc but I don't make any changes, I would like the date to stay the same as it was previously.
I think from searching elsewhere this can be done with VBA but I have no experience in this area at all so I was hoping someone could show me a way this could be done just using formulas if possible.
Any help appreciated.
Many thanks, Warren.