Hello.
I am trying to calculate some data in excel using start and end dates for absence.
I have some absence data (attached an example) for staff that contains their Start Date and End date of the absence. Basically I need to be able to calculate:
1 - the number of consecutive months someone has had absence
2 - the max number of consecutive months someone has been off.
Any help would be greatly appreciated.
Bookmarks