View original (French)

[Google Sheets] Show cell modification date

Cmoi2025 -  
Hello

I need to display the modification date of hundreds of cells in a column in the right column next to each relevant cell.
Is there a function that shows the modification date (and time if possible) of the cell on the left?

Thank you in advance.

2 answers

  • Votes
  • Date
  • Descending date
  2. PapyLuc51
    Hello

    In B2 for A2

    =IF(A2<>"",NOW(),"")

    Best regards
    1. Cmoi2025
      Hello
      It's a lead, but the date keeps changing
      I'm looking to display the modification date of the cell
    2. PapyLuc51
      @Cmoi2025Yes indeed, I think we'll need to go through VBA; so I'll leave you in expert hands.

      Best regards
    3. PapyLuc51
      Hello,

      In fact, regarding VBA, it's more about the JAVA language on Google Sheets.

      While searching online, I found this VBA code that works very well on Excel; the date and time only change if you modify the cell to the left. Since I have no knowledge of English, I don’t understand what it means other than selecting the source column. 

      Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Application.Intersect(Target, Range("A:A")) Is Nothing Then
      Target.Offset(0, 1) = Now
      End If
      End Sub


      There’s certainly someone who can translate this into language for Sheets.

      Best regards.