I'm sorry Deepak, it is reattached.
Thank you for your help. Its close but not quite what I need.
I'd like the calculation to based off the Name and Date, not the number of records. (This reasoning is someone may be "off" but still have records).
I'd like to assign 'Off' ( blue X) to John from April 3 to April 9 and OFF to Jessica from April 4 to April 5. Everything else should be 'Working' (green X)