I was wondering if there is a formula to check this out
if someone takes personal day it is 1 occurrance
but if they have more then 1 day in a row off it is 1 occurrance
example
4/24/06 personal day 1 occurrance
6/24/06 personal day
6/25/06 personal day
instead of these being 2 single occurrances it is consider 1 occurrance for the 2 days off in a row, but this can be more then 2 days also
so what i need to show is that the person only has 2 occurrance and not 3
if someone takes personal day it is 1 occurrance
but if they have more then 1 day in a row off it is 1 occurrance
example
4/24/06 personal day 1 occurrance
6/24/06 personal day
6/25/06 personal day
instead of these being 2 single occurrances it is consider 1 occurrance for the 2 days off in a row, but this can be more then 2 days also
so what i need to show is that the person only has 2 occurrance and not 3