B
blazzzercat via OfficeKB.com
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.
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.