I need to track days/hours absent from work using one column for dates and a
second column for total hours absent. Each absence is considered an
occurrence, but consecutive days of absence are only considered to be a
single occurrence. In other words, if an employee is absent on Monday, it is
one occurrence, if s/he is out Monday and Tuesday it is one occurrence, but
if s/he is absent Monday, comes to work on Tuesday and is out again on
Wednesday, each absence would be considered a single occurrence for a total
of two that week. Is there a formula that will check the cells in the hours
column, and if they are not empty, check the dates in the date column to
determine if they are consecutive dates, thus determining the number of
occurrences? Thanks in advance€¦