Hi There

I have a workbook with 2 sheets, I have the same dates on sheet one and two and I am trying to use VLOOKUP to match them. However it is not working as excel is calculating the same date differently on both sheets. IE on sheet one when I express 2.9.02 18:58 as a number I get 37501,79059 while the same date on sheet two is calculated as 37501,79028 ??

any Ideas as why this is?

Thanks