excel formula to show last modified date for a specific cell

[tshepolt]

excel formula to show last modified date for a specific cell if the value changes

[bebo021999]

excel formula to show last modified date for a specific cell if the value changes

So you have nothing to say anymore?
Provide range, cell address and what is your expected results.

[tshepolt]

sorry about that

I've attached a file as reference,
If the prices change in column "D", then the date in column "A" should change displaying the date the price was changed for that specific cell

Please help

[bebo021999]

It required VBA, which i am not familiar with.

[davsth]

Assuming the values are just overtyped you need to go down a visual basic route based on a change event, see the link below

https://www.extendoffice.com/documen...l-changes.html