View original (French)

Display the current date if the next cell is filled

meganou47 Posted messages 1 Status Membre -  
Pierr10 Posted messages 13781 Registration date   Status Modérateur 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 réponses

Réponse 1 / 2
tricolore56 Posted messages 4 Status Membre 1
 

Hello,

a simple solution,

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

best regards
1
Pierr10 Posted messages 13781 Registration date   Status Modérateur Last intervention   5 819
 

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
Réponse 2 / 2
brucine Posted messages 24501 Registration date   Status Membre Last intervention   4 115
 

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
brucine Posted messages 24501 Registration date   Status Membre Last intervention   4 115
 

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

0