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]

thanks

Thanks very much for the help Oaktree

I will try all this and hopefully we have covered all areas(keeping fingers crossed)

I had a good sheet working till company got bought out and new company changes things

Again many thanks for the help

 

[UPN]

one quick question

is the last formula you gave an an arrray formula? dont know enough on arrays

 

[Oaktree]

No.

C1=--AND(ISNA(MATCH(WORKDAY(A1,1,$H$1:$H$25),$A$1:$A$100,0)),B1<>"a",A1>(TODAY()-90))

is a regular formula.

 

[UPN]

thanks

Ran into problems with column i needed to put in, already had formula in it, but figures out what to do.

Tested it and is working great

Many, many thanks

 

[UPN]

trouble

I just found out today that is people that work Saturday and Sunday

so I guess now I only need the formula to check holidays, so which one do i use from all the examples given before

Thanks for the help

 

[Oaktree]

If (some) people work Saturday and Sunday, wouldn't (some) people also work holidays?

I'm thinking that the

{=SUM(--ISNA(MATCH(A1:A10+1,A1:A10,0))*(A1:A10<>"")*(A1:A10>(TODAY()-90)))}

formula from the first page might suffice.

 

[UPN]

no

they dont work holidays

 

[Oaktree]

Does your holiday schedule have any consecutive holidays?

 

[UPN]

no

 

[UPN]

yes
thanksgiving and day after