Determine if a date falls between two dates

[sunrise06]

I am trying to determine if a date falls between two dates. I am using the following formula:

=IF(AND(A2>=$D$1,A2<=$E$1),"T","F") with D1=8/27/2018 and E1=8/27/2018

I get the right answer. However, if I change the formula and replace the absolute reference dates with actual dates as shown here, I do not get the right answer.

=IF(AND(A2>=8/27/2018,A2<=8/27/2019),"T","F")

Any ideas why?

Additionally, if anyone has a better formula, I need a formula to review over several years.

Thanks

 

[Joe4]

It is treating is as division and not a date.

Here is one way to get around that:
=IF(AND(A2>=DATEVALUE("8/27/2018"),A2<=DATEVALUE("8/27/2019")),"T","F")

 

[sunrise06]

Ahh, thank you! I was stumped. Any suggestions on how to create a formula for looking over several years. For example:

START DATE	END DATE
8/27/2014​	8/27/2015​
8/27/2015​	8/27/2016​
8/27/2016​	8/27/2017​
8/27/2017​	8/27/2018​
8/27/2018​	8/27/2019​
8/27/2019​	8/27/2020​
8/27/2020​	8/27/2021​

 

[Joe4]

Any suggestions on how to create a formula for looking over several years.

Not sure what you mean.
What seems to be the difficulty?
Why would it be any different?

 

[sunrise06]

I wondered if there was a better formula rather than stringing along ALL of these dates in one formula.

Thnaks

 

[Joe4]

Ah, I think I see now. Since they all are the same day and month, here is one way:
=IF(AND(YEAR(A2)>=2014,YEAR(A2)<=2021,MONTH(A2)=8,DAY(A2)=27),"T","F")

 

[sunrise06]

Ok, thanks