Last modified date of a cell, in an adjacent cell

[hop3y]

My sheet uses =CONCATENATE to put cells F2, G2, H2 and I2 together into S2. I would T2 to show the date that S2 was last modified.

I've searched high and low and can't find a formula for this, would this require VBA?

Any help would be greatly appreciated.

 

[Joe4]

I've searched high and low and can't find a formula for this, would this require VBA?

Welcome to the Board!

The answer is "Yes", it will require VBA. Cells can contain formulas, or hard-coded values, but never both at the same time.
So, if you use an Excel function like TODAY() or NOW(), it is always going to show the current date/time.
If you want to capture the day/time something is last modified, you need to use VBA/.
If you search this forum on "Date Stamp" or "DateTime Stamp", you will find hundreds of posts on this, that will show you how to do this (the question is literally asked every day!).

 

[hop3y]

Welcome to the Board!

The answer is "Yes", it will require VBA. Cells can contain formulas, or hard-coded values, but never both at the same time.
So, if you use an Excel function like TODAY() or NOW(), it is always going to show the current date/time.
If you want to capture the day/time something is last modified, you need to use VBA/.
If you search this forum on "Date Stamp" or "DateTime Stamp", you will find hundreds of posts on this, that will show you how to do this (the question is literally asked every day!).

Thanks for the reply. I have searched the forum prior to this, but can't find anything that specifically helps.

Are there any threads that you could point me in the direction of?

 

[Joe4]

Do a Google search on "excel vba timestamp site:mrexcel.com", and you will see tons of these threads.