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

Joseph Huisman

With the permission of everyone, here is another solution without VBA.

Simply with a formula.

=IF(C1="","",TODAY()) in english

=WENN(C1="";"";HEUTE()) in German

Info in the inserted file.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)

AAAA_TODAY_Formula.xlsx9 KB

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.