If Cell Value Equal Or Between

[JIMBOB77]

Hi - To Simplify My Question

A1 - Start Date
A2 - End Date
A3 - Contains 3rd NOV
A4 - Result

So In A4 I Want To Return The Result As Follows...

If A3 (3rd Nov) Falls On Or Between The Dates Shown In A1 and A2 Then The Result Is "1", If Not Then The Result Is Zero

Thanks

 

[wideboydixon]

In A4:

=(A3>=A1)*(A3<=A2)

WBD

 

[jmacleary]

Try =IF(AND(A3>=A1,A3<=A2),1,0) in A4.
John