Matching dates in excel

[supermax77]

Im trying to work out if date in column A falls between date in column B and date in column C. I've tried so many formulas and cant work out what im doing wrong! please help!

 

[PeteWright]

This works for me:

MrExcel_2024-06.xlsm
	A	B	C	D
1	7/7/2024	6/1/2024	8/1/2024	TRUE
Sheet2

Cell Formulas
Range	Formula
D1	D1	= AND(A1>=B1,A1<=C1)

 

[supermax77]

This works for me:

MrExcel_2024-06.xlsm
	A	B	C	D
1	7/7/2024	6/1/2024	8/1/2024	TRUE
Sheet2

Cell Formulas
Range	Formula
D1	D1	= AND(A1>=B1,A1<=C1)

thanks for this - it's the exact formula ive been trying and it wont work despite how simple it seems - i think i may have an error elsewhere...

 

[Alex Blakenburg]

A common cause for it not working is that one or more of the cells are text and not a number (a date being a number).
Select A1:C1 change the format to General (ctrl+shift+~ will do it).
Do all 3 values change to a number ?
Ctrl+Z to undo the formatting change.

Are there formula in the 3 cells and if so what is the formula ?