Using IF, And, OR, functions Together

[Flash202]

I am trying to create an if statement that will determine if the hire date occurred during the period date range and mark the cell with a 1. If the termination occurred during the same period, the NEXT period will be marked with a 0. If there is no termination date then all periods should be marked with a 1. If there is an easier way for me to do this please let me know, any help with this will be greatly appreciated, please see the example below of how the formula should work.
-ThanksExample.JPG

[bebo021999]

Assuming C4:hirie date; D4: Term date; F1: start; F2: End

In F4 then drag down and accross:

=(MIN($D4,F$2)-MAX($C4,F$1)>0)+0

[Flash202]

Thanks so much this seems to work perfectly!