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 answer

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    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
    1. Yacine
       
      Thank you, it was quick and perfect, 10/10 my friend.
      0