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
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