Creating a summary box from existing employee absence data

Hi,

I am using the attached excel template 'Employee absence tracker' and would like to add a little more summary info if possible. The first point is the most important but the others would be really helpful if anyone could help me find a way!

1) Company total 'Days on leave' and the associated breakdown (eg. sick, vacation, bereavement etc), so adding together all employees data for the 1 year.

2) Switching from calendar year (1 Jan - 31 Dec) to tax year (5 April - 4 April)

3) Adding a column next to employee name for their relevant department (ie. admin, IT, production etc) so that I could get a breakdown of total absences over the year by department.

I don't know how feasible any of these points might be but I would greatly appreciate any help! Thanks

Thank you so much, that is perfect! Have added it in now :D