Automatically adding the date/time to a cell when another cell is updated

I am trying to create a spreadsheet where when a specific cell is updated in anyway, the date/time stamp automatically updates in the cell right beneath the cell that was updated. I only need to have...

excel

nne1071

Copper Contributor

Sep 20, 2022

kovesp

many thanks for your formula, it works for me, just the problem is that if I update lets say C1, it does update the date/time into all lines & not only B1 as I was expecting. What is my mistake?

Ouche1195

Copper Contributor

Oct 29, 2022

@kovesp

Hi I have the same issue
my spreadsheet has steps and when a step is changed or edited another cell should reflect the date
and since i have many steps I need to see many dates to know when each step was edited

for example:
cells with content to be edited are :
J8, J14, J23,P8,P14,P23

and cells that should reflect changes date are:
I11,I17,I26,O11,O17,O26

So cell I11 should show the date when J8 is edited
(whenever J8 is edited, I11 should update the date)
and whenever J14 is edited, I17 should update the date (show the date),
and so on

I tried =IF(J8="","",NOW())
and I tried =IF(J14="",IF(I17="",NOW(),I17),NOW())
and tried =IF(ISBLANK(P14)," ",NOW())
and tried =IF("$P8"="","",NOW())
and =IF(P8<>"",IF(O11="",NOW(),O11),"")
all of them are working but with 2 problems:
- if i edit any cell in the sheet, the date is updated
- but it is updated in all the cells that contains this formula despite that the formula in each one has different cell number as referred above

any help is appreciated
thank you in advance

Forum Discussion

Automatically adding the date/time to a cell when another cell is updated