| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figure out date from total days in year | Excel Worksheet Functions | |||
| Calculating total number of days | Excel Worksheet Functions | |||
| sum of rolling (set number cells above the total)l | Excel Discussion (Misc queries) | |||
| Calculating number of Saturday's in a Year | Excel Discussion (Misc queries) | |||
| Number of days in a year | Excel Discussion (Misc queries) | |||
Linear Mode
