Excel: Find and dates data across sheets


Hi all, i have a workbook which consists of 2 sheets. in each sheet i have a unique ID and the date next to it such as sheet 1

98531 11/10/2014
86521b 8/8/2014
66363d 1/1/2014
sheet 2
86521b 10/8/2014
98531 15/10/2014
66363d 6/1/2014
what i need to do is first find the data from sheet 2 which matches sheet 1. then minus sheet two date from sheet 1 to give me the amount of days difference. any help will be much appreciated


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of November 10, 2014.


For more resources for Microsoft Excel