Computerised10
New Member
- Joined
- Oct 2, 2014
- Messages
- 20
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
<tbody>
</tbody>
sheet 2
<tbody>
</tbody>
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
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 |
<tbody>
</tbody>
sheet 2
86521b | 10/8/2014 |
98531 | 15/10/2014 |
66363d | 6/1/2014 |
<tbody>
</tbody>
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