View original (French)

IF function between two dates

Solved
lahkar7 Posted messages 31 Status Member -  
lahkar7 Posted messages 31 Status Member -
I want to find if the date in "C4" is between "F3 & G3" so "C20" = 01/01/2015
AND if the date in "C4" is between "F4 & G4" so "C20" = 01/04/2015
AND if the date in "C4" is between "F5 & G5" so "C20" = 01/10/2015
AND if the date in "C4" is between "F6 & G6" so "C20" = 01/10/2015
See Image
Thank you my friends

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    in C20:

    =IF(C4="","",IF(C4<=G3,F3,IF(C4<=G4,F4,IF(C4<g5 />
    if you don't want to include the limit in the condition, remove the = sign

    regards

    --
    To err is human, to persist is diabolical
    1
    1. lahkar7 Posted messages 31 Status Member
       
      Please help me
      I want in cell "C9" the age in years between the current year and the date of birth without fractions, meaning 40.55 will be 40 and not 41
      Thank you
      0
    2. lahkar7 Posted messages 31 Status Member
       
      Your response is very good except instead of C6 (at the end) we put F6, I know it’s a typo, thank you very much.
      0