Cross reference data in 2 columns, time and shift

Hi there,

I put together an example of a spreadsheet where i would like to have automatic updates as new information is inputted. On tab 1 will be where i update the information, and on tab 2 i would like to have 3 separate data boxes, 1. to list injuries by shift. 2. injury by hire date and finally data that shows injuries on shift 1 under 6months, 6months-1year and then everything over 1 year..... this would continue for shifts 2 and 3 as well.

I can't seem to figure out what formula to use, or maybe i am not writing it correctly.

See example workbook.

thank you, i hadn't noticed there was no header... it is the month of service

In this particular mockup, each line in sheet1 is for an incident, sheet 2 B3:E9 represents the days since the last incident for each dept, per shift...