I have a lengthy file of absence data and I am trying to calculate the lenght
of absence (ie number of days) but can't seem to figure this out. I can
easily figure out the 1 day absences but I can't figure out how to do a
formula around the different amount of entries for each person, different
coding for each person, etc.

A B C
EE1 JAN 1/06 SICK1ST
EE1 JAN 2/06 SICKCON
EE1 JAN 3/06 SICKCON
EE1 MAR 1/06 SICK1ST
EE2 FEB 12/06 SICK1ST
EE2 FEB 27/06 SICK1ST
EE3 JUN 12/06 SICK1ST
EE3 JUN 13/06 SICKCON
EE3 JUN 14/06 SICKCON
EE3 JUN 15/06 SICKCON
EE3 JUN 16/06 SICKCON
EE3 JUN 17/06 SICKCON
EE3 SEP 1/06 SICK1ST
EE4 MAR 3/06 SICK1ST
EE4 MAR 4/06 SICKCON
EE4 APR 12/06 SICK1ST
-
Lori16