I am using to two workbooks. One of the workbooks Looks Up data from the other. We recently updated one of the workbooks for our UK Firm. The UK file was created by a US Mac user. I am using XP 2002.
Problem: File A looks up a date from File B. Originating date in File A 1/31/2008. Date in...