ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculating total number of days in rolling year (https://www.excelbanter.com/excel-worksheet-functions/249694-calculating-total-number-days-rolling-year.html)

Suede

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.

Fred Smith[_4_]

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