How to timestamp in Excel when cell changes

#exceltips #excelcourse #Exceltimestamp
In this video, you will learn how to inset a timestamp automatically when a cell changes.

The formula used is available on the page above

remember to change C2 and D2 cell accordingly. Replace D2 with the cell that will hold timestamp. Additionally, C2 is the cell that will change.

[samuelbrummer]

Use the Lambda function to hold the time in place (no VBA needed) =lambda(now, cell, if(len(cell), now, ))(now(), A2)

[billhughes]

For me, this only works when I hit "Save" on the file.

[crumbs]

How do you keep the date stamp from changing to current date?

[umwtfwasthat]

You will need to turn off iterative calculations for this formula to work.