Calculating total number of days in rolling year

[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.

 

[Fred Smith]

It depends on what your data looks like. Tell us about your data structure.

Regards,
Fred.