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)