Joining different tables on a date field

Hi,

I am trying to do a comparison on the number of records from two different excel sheets based on a common date.  Here is what steps that I took.

1.  Since there are different dates on two different worksheets, I basically created another worksheet "date", copied and paste the date fields from each of the 2 worksheets.  Then I removed the duplicates.  This essentially becomes a reference date table of all the possible date entries in each of the two worksheets.

2.  I did a left join using one of the worksheet (Comfy) onto the date table.

However, when I try to do a left join using the other worksheet (Sterling Bay) onto the date table, it creates duplicates.  I am pretty sure I'm doing it wrong, but wanted to see if anyone here could help.  I attached the workbook and the general data flow.

The Comfy worksheet tab has a total of 9047 records and the Sterling Bay tab has a total of 981 records.

Any assistance would be greatly appreciated!

Thanks.