excel formula to tell if a date (formatted as date) is within range of other dates

[billyheanue]

hi all,

I'm trying to determine if a date in column A is within the range of dates specified in column B (date start) and column C (date end).

Each column, A, B, and C, is formatted as Date.

Is there a way to do this?

Example:

PO Date CT Start Date CT End Date In CT Range?

1/15/2016 12/31/2015 12/31/2017 YES



Thanks!

 

[AlanY]

try

=IF(AND(A1>=B1,A1<=C1),"YES","NO")

 

[billyheanue]

Worked perfect!
Thanks

 

[AlanY]

you're welcome