Missing Dates in two columns

Hi,
I am struggling with the below scenario. Your help is gonna save lot of manual work. Thanks in advance.
Below are two sheets in my excel.
Sheet1
Col1(obj) Col2 (Trade Date)
ob1 2014-20-01
ob1 2014-21-01
ob1 2014-24-01
ob2 2014-20-01
ob2 2014-22-01
ob2 2014-23-01
ob3 2014-24-01

Sheet2
Col1 1(All trade dates exceluding weekends and holidays)
2014-01-20
2014-01-21
2014-01-22
.....
2014-12-29
2014-12-30
2014-12-31

I want to find out for each object which all trade date is missing.(when compared to All trade dates in sheet2 )
So I am expecting an output as below in new sheet.
Sheet3
Col1 (obj) Col2 (Missing Dates)
obj1 2014-22-01
obj1 2014-23-01
obj2 2014-21-01
obj2 2014-24-01
Obj3 2014-20-01
...... ...........

Please help me out.

Thanks,
Abhishek

Thanks Ford for the welocme and quick reply back.
I tried the above query but it didnt fetch me the result.

May be my explaination was not proper.
I have attached the excel. and below is the sheet expalination

Sheet1- Objects and Actual Dates
Sheet2- Trade calendar of the whole year

Sheet3- Expected output. For each object which all dates are missed out in sheet1 as per the trade calendar

Apreciate your help.
Abhishek

Yes Naveed, Bang on.

Originally Posted by Naveed Raza

Hi Abhishek

Please find the attached file and i hope this will work as u want

Thanks NAveed for your prompt response.
It works right for the data in sample excel.
But when I copy some mopre objects and dates in sheet1, it gives me all dates as missing for all objects.
Any change in the macro code which can resolve this issue?