This is for an Excel attendance worksheet. Entries are made for each day an
employee calls in as being absent (calloff).

What I am looking for is if 2 €œcalloffs€� happen in a row they only count as 1
€˜Occurrence
(multiple day call ins only count as 1 occurrence.)

If employee calls off on Feb 2 and calls again on Feb 3, this in only one
€˜Occurrence (they are only allowed 3 occurrences). But if they call in on
Feb 5th this is a 2nd occurrence.

I am looking for a formula to automate the counting of occurences.

Thanks so much.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1