Find Dates On One Sheet and Calculate Days Since on Another Sheet

[wjmcmanus663]

Any help to solve this problem would be greatly appreciated, thank you in advance!
From an injury log for several departments, I would like to calculate the days since last injury for each department, on a separate sheet within the workbook.
I need a formula to pull the the latest injury date for each department and then calculate the number of days from that date.

Here is what I'm trying to accomplish:

<colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> </colgroup><tbody>
[TD="class: xl70, width: 265, colspan: 3, align: center"] Worksheet 1
[/TD]

[TD="class: xl81"] Employee
[/TD]
[TD="class: xl82"] Date of Injury
[/TD]
[TD="class: xl69, width: 75"] Department
[/TD]

[TD="class: xl78"]John Doe[/TD]
[TD="class: xl79"]1/2/2015
[/TD]
[TD="class: xl80"]Radiology[/TD]

[TD="class: xl73"]Jane Smith[/TD]
[TD="class: xl72"]2/2/2015[/TD]
[TD="class: xl74"]Emergency[/TD]

[TD="class: xl73"]Roger Dodger[/TD]
[TD="class: xl72"]3/3/2015[/TD]
[TD="class: xl74"]MST[/TD]

[TD="class: xl73"]Lolly Pop[/TD]
[TD="class: xl72"]3/27/2015[/TD]
[TD="class: xl74"]Emergency[/TD]

[TD="class: xl73"]Charlie Glad[/TD]
[TD="class: xl72"]4/4/2015[/TD]
[TD="class: xl74"]Radiology
[/TD]

[TD="class: xl75"]Humpty Dumpty[/TD]
[TD="class: xl76"]4/15/2015[/TD]
[TD="class: xl77"]MST
[/TD]

</tbody>

____________________________________

<colgroup><col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="width:56pt" width="75"> </colgroup><tbody>
[TD="class: xl74, width: 157, colspan: 2, align: center"] Worksheet 2
[/TD]

[TD="class: xl76"] Department
[/TD]
[TD="class: xl69, width: 75"] Days Since Last Injury
[/TD]

[TD="class: xl81, width: 82"]Emergency
[/TD]
[TD="class: xl82, width: 75"]187
[/TD]

[TD="class: xl77, width: 82"]MST[/TD]
[TD="class: xl78, width: 75"]168
[/TD]

[TD="class: xl79, width: 82"]Radiology[/TD]
[TD="class: xl80, width: 75"]179
[/TD]

</tbody>

 

[wjmcmanus663]

Thank you for that detailed and easy to understand explanation and once again for all your help today, much appreciated! I will watch the video as well.

 

[DRSteele]

You're welcome. I hope you keep coming back to the forum to get help and to help others. And watch those videos!