View original (French)

IF function between 2 dates

Solved
Joe35 -  
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 answers

  • Votes
  • Date
  • Descending date
  1. via55
    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
    1. Cellequitaime
      You're welcome!!!!!!!!!!!