View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HANNAH82 HANNAH82 is offline
external usenet poster
 
Posts: 2
Default Instances of an occurance over 12 months

Hi,

I'm trying to set up, in excel, a way of calculating the number of days an
employee has off sick within a rolling year. At present i have it set so it
calculates the number of working days between two dates, repeating this each
time the person is off. It then calculates the total days (using a simple
SUM of). I have also set it so it puts in todays date.

Any help would be apreciated!!!

Thanks