![]() |
Calculating total number of days in rolling year
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. |
Calculating total number of days in rolling year
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. |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com