Sickness Monitoring

[Tesfalidet]

Hey
I'm trying to set up a spreadsheet which will let me track sickness for members of staff over a rolling 12 month period. So far I have: First day of sickness, Last Day of Sickness, Number of Days

I would like to add a column that gives me the total number of days over the last 12 months from today's date and a column that totals up the number of occurrences over the last 12 months from the date or enquiry???

This is way beyond me - any help GREATLY appreciated!

Tes

 

[7naumankhan7]

Email me a working file to 7naumankhan7@gmail.com and I'll see what I can do. Please also describe exactly what you want the sheet to do in a list.