Forum Discussion

Copper Contributor

Oct 01, 2018

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

NikolinoDE

Gold Contributor

Apr 15, 2021

Please don't forget to change the date format of the cells

Carly_Forrester

Copper Contributor

Apr 20, 2021

Hi there, I'm looking to have a column that updates whenever any cell in that row is updated. I'm just having trouble coming up with a formula. Could you help?

Thanks!!!

NikolinoDE
Gold Contributor
Apr 21, 2021
Carly_Forrester
I cannot follow your flow of thoughts.
Please attach a file (without sensitive data) and on the basis of this you explain your plan in detail.
It makes no sense that we are constantly producing files that are not what you imagine.

It is good to read this information in advance:
Welcome to your Excel discussion space!

Thank you for your patience and understanding

Nikolino
- kovesp
  Copper Contributor
  Sep 04, 2021
  See my reply below, but use this instead of the first version:
  =IF(COUNTA(C1:Z1)=0," ",NOW()).
  Adjust for however many columns you want to cover in the row.
  
  Sorry replied to NikolinoDE instead of Carly_Forrester.