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

Regards,
Fred.

"Suede" wrote in message
...
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.