Determine if a certain date is within a range

[miss_chloe]

I saw a formula however it only uses cell number, this is what i saw

Please Login or Register  to view this content.

a1 = compare date
a2 = start date
a3 = end date

What im looking for is to insert the date itself not the value of a cell

a1 = July 15, 2013

Please Login or Register  to view this content.

I'm not sure if that's how you should encode it, but it always shows false, even though it should say true since July 15, 2013 is between those dates.

[oeldere]

2 things,

it much easier to refer to a cell (your file will get more dynamic)

you get better help if you add an example of your file, without confidentional information.

[Tony Valko]

Better to use cells but if you don't want to use cells try it like this:

=AND(A1>=DATE(2013,7,1),A1<=DATE(2013,7,30))