View Single Post
  #1   Report Post  
smskater
 
Posts: n/a
Default Counting the number of times someone called in sick

How do I count the number of times a person has called in sick?

9/1/05 work
9/2/05 work
9/3/05 sick
9/4/05 sick
9/5/05 work
9/6/05 sick

The above example shows the person called in sick 2 times for 3 days.
How do I create a formula that reflects this?

thanks