View original (French)

If a cell contains a date, then it displays 2.

Solved
Yacine -  
 Yacine -
Hello,
I will explain
And thank you in advance, friends
I would like that if I enter any date between 1/1/2015 and 30/7/2020 in cell A1, it displays '2' in cell B1
Is this possible, friends? I couldn't find the right 'if' formula, thanks

Configuration: Android / Chrome 84.0.4147.111

1 réponse

Réponse 1 / 1
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

=IF(AND(A1>=DATE(2015,1,1),A1<=DATE(2020,7,30)),2,"")

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
0
Yacine
 
Thank you, it was quick and perfect, 10/10 my friend.
0