Forum Discussion
If row is updated add today's date
Hi. I'm struggling to get the correct formula - help please!
In my Excel spreadsheet I want to have the date added when each row is edited or updated.
If row is updated then enter =TODAY() in cell A2
Thank you
Make sure that you allow macros when you open the workbook.
Right-click the sheet tab and select View Code to inspect and modify the VBA code.
4 Replies
=TODAY() will update automatically each day, so it would return 27-Mar-2025 today and 28-Mar-2025 tomorrow.
What you want requires VBA code, so it works only in the desktop version of Excel, and all users will have to allow macros. Is that OK?
Thank you Hans, that's ok and I would like to give it a try.
Make sure that you allow macros when you open the workbook.
Right-click the sheet tab and select View Code to inspect and modify the VBA code.
