I have one worksheet that lists employee numbers in one column and dates
they have worked in the second column:
Emp # Date Worked
1233 12/1/06
1233 12/2/06
1233 12/3/06
1234 12/1/06
1234 12/2/06
1234 12/3/06

The other worksheet lists employee numbers in one column, then calendar
dates are listed along the top row:
12/1/06 12/2/06 12/3/06
1233
1244

What I would like to do, is pull the information from the worksheet with the
dates worked and have it put a 1 in the cell if that paricular employee
number worked that day, and a 0 in the cell for days not worked:

12/1/06 12/2/06 12/3/06 12/4/06 12/5/06
1233 1 1 1 0 0
1244 1 1 1 0 0


Can anyone help me with a formula that will do this?

Any help is appreciated.
Thanks