I am hoping to find a solution to my problem, however I may be asking excel to do to much.
I have an absence excel spreadsheet, that has 12 sheets (one for each month) and is set our per employee. On each month you find the employee's line and enter either "S" - Sickness, "P" - personal, "H" - Holiday. However my manager's want some sort of analysis that would put years of data together that would tell them whether someone has a sick day the same time each year. Or if there is a trend that they have 2 sickness days then a personal day, the same time each year. I have only set this spreadsheet up this year (based off a template from the internet) so don't currently have historical data in the same format, however will be using the same format going forward with a new document each year.