Deduction of dates issue, macros

Hi everyone,
I would really appreciate your help.. Here is a summary -
I have 2 sheets - Sheet1 and Sheet2. On both sheets I have column 2, which contains the name of the country, and column 3, which contains the name of the product. Column 7 contains the date in dd/mm/yyyy format, but the dates are different on different sheets.
The task is to deduct column7/sheet1 from column7/sheet2 and to put it in column8/sheet2.
I have written a part of the macros, which checks if column2 and column3 values are the same on 2 sheets - code is below. So in anyone could help me with deduction part - it would be great. Thanks a lot!!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I found the reason of the error - i have some cells with "done" value instead of date. Is there any way to skip rows with non-numeric value?

You could add an IsDate(cell) test to each of the dates that might be wrong.

I added IsDate check for both sheets - now macros runs, but provides no result. I even tried to change the format of display from Mar-13 to 01/03/2013.

Can you post the workbook for us to look at?

Actually I found the final mistake - format of the previous sheet was a bit different. Now everything works fine, i only had to modify the deduction formula to have number of months as a result.
Thanks a lot!