View original (French)

Display the current date if the next cell is filled

meganou47 Posted messages 1 Status Member -  
Pierr10 Posted messages 13855 Registration date   Status Moderator Last intervention   -

Hello,

I am at an impasse. I created an Excel file for tracking ratings, and I would like the current date to appear in cell A2 when I fill in cell C2.

Thank you in advance for your help.


2 answers

  1.
    tricolore56 Posted messages 4 Status Member 1
     

    Hello,

    a simple solution,

    IF(C2="", "", TODAY())

    best regards

    1
    1. Pierr10 Posted messages 13855 Registration date   Status Moderator Last intervention   5 854
       

      Hello,

      I would like to add to the (very) good solution provided by tricolore56:

      • Don’t forget the = in front of the formula given, to be placed in A2
      • Format cell A2 as a date
      0
  2. brucine Posted messages 25212 Registration date   Status Member Last intervention   4 176
     

    Hello,

    The date of the day is by definition volatile, there's no choice but to use VBA, something like this:

    https://www.developpez.net/forums/d1643344/logiciels/microsoft-office/excel/date-jour-date-modification-d-cellule/

    0
    1. brucine Posted messages 25212 Registration date   Status Member Last intervention   4 176
       

      Or the manual way, but which is not automatic: every time we modify C2, press CTRL+; in A2.

      0