FORMULA IF TODAYS DATE IS BETWEEN 2 DATES

[garypea123]

Good Afternoon,

A nice easy one.

A1 = 01/02/2024
A2 = 07/02/2024

In a A3 what formula would I type that would give a "YES" if TODAY() is between between (and including the 2 dates?

 

[etaf]

=IF(AND(TODAY()>=A1,TODAY()<=A2),"Yes","No")

Book1
	A	B	C
1	2/1/24
2	2/7/24
3	Yes		TRUE
Sheet1

Cell Formulas
Range	Formula
A3	A3	=IF(AND(TODAY()>=A1,TODAY()<=A2),"Yes","No")
C3	C3	=AND(TODAY()>=A1,TODAY()<=A2)

 

[garypea123]

Absolutely perfect!! Your a diamon

 

[etaf]

you are welcome

 

[Scott Huish]

Another way:
=IF(MEDIAN(A1,A2,TODAY())=TODAY(),"Yes","No")

 

[garypea123]

Perfect Also - Always more than one way to get the same same result.