more then 1 day

[UPN]

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

 

[UPN]

ok

thank you

hopefully this is done now,

Again I greatly appreciate the help

 

[UPN]

question

{=SUM(--ISNA(MATCH(A1:A10+(1+ISNUMBER(MATCH(A1:A10+1,H:H,0))+(A1:A10=("11/22/2006"+0))+(A1:A10=("12/23/2006"+0))+(A1:A10=("12/30/2006"+0))),A1:A10,0))*(A1:A10<>"")*(A1:A10>(TODAY()-90)))}

Can i enter the dates for 2007 as well as 2008 from the above formula also, or is it to much

 

[UPN]

Forget it i figured it out