Calculating total number of days in rolling year

  • Thread starter Thread starter Suede
  • Start date Start date
S

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.
 
It depends on what your data looks like. Tell us about your data structure.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

YEAR MONTH DAYS COUNTER 6
Calculating a rolling calendar year 2
Calculate number of days 6
Calculating total number of days 3
Calculate Number of Days worked in Each Month by Project 2
problem with days months and years conversion 1
Excel - Calculate age from DOB in years, months days 7
Calculate Days Left in Current Year 3

Back
Top