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)