View original (French)

IF function between two dates

Solved
lahkar7 Posted messages 31 Status Membre -  
lahkar7 Posted messages 31 Status Membre -
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 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
lahkar7 Posted messages 31 Status Membre
 
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
lahkar7 Posted messages 31 Status Membre
 
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