Hi I would welcome any guidance you could give me about calculating the number of days in a rolling year.
The items below are my column headings
First Day of Absence/Last Day of Absence/number of days off/number of sick days within a 12 month period/number of sick periods in 12 month period
Example data
Column A First day = 13/08/2013
Column B Last Day = 20/08/2013
Column C Number of days off - I have used =NETWORKDAYS(a2,c2)
Column D No of sick days within 12 months - This is where I need help I need a formula that will look at the Date in column B and then calculate how many days have been taken in the previous 12 months
Column E No Sick periods - Again how do I calculate the amount of times opposed to days that someone has been off.
Any help would be greatly appreciated
Thank you
Bookmarks