[Excel 2010] Reporting Absence Data

[Gongalong]

Hi folks,

 

We've got an (Excel 2010) spreadsheet that has staff absence data. So far this contains 2 years of data, with each year in a different sheet.

 

This data needs to be reported for the last 12 months on a rolling weekly basis.

 

Can anyone see an elegant way of doing this in Excel? (I'm guessing it would be made a lot easier by merging both years into one sheet)

 

TIA