View original (French)

IF function between 2 dates

Solved
Joe35 -  
 Cellequitaime -
Hello,
I would like to use an IF function between two dates but I can't get a result. Here is the formula I tried
= IF(AND(B1>=01/07/2014;B1<=30/06/2015);"fiscal year 2014-2015";"fiscal year 2013-2014)
In B1 I have cells with dates

Thank you for your help

Configuration: Windows 7 / Chrome 41.0.2272.118

2 réponses

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

Try:
= IF(AND(B1>=DATEVALUE("1/7/2014"),B1<=DATEVALUE("30/6/2015")),"fiscal year 2014-2015","fiscal year 2013-2014")

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
7
Cellequitaime
 
You're welcome!!!!!!!!!!!
1