Calculating total number of days in rolling year

  • Thread starter Thread starter Suede
  • Start date Start date
S

Suede

I'm a novice to Excel and using Excel 2002 ver. I need to keep track of
employee absences for my company in a "rolling" 12 month period. e.g. if an
individual is permitted "x" days off/year and absent from work more or less
than the allocation -what would the formula be to determine an available
total on any day of the year.
Thanks.
 
It depends on what your data looks like. Tell us about your data structure.

Regards,
Fred.
 
Back
Top