View original (French)

IF function between two dates

Solved
lahkar7 -  
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

  • Votes
  • Date
  • Descending date
  1. Vaucluse Contributor
    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. lahkar7 Author
      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
    2. lahkar7 Author
      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.