Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn
 
Posts: n/a
Default Rolling year

I have an attendance report and our policy is based on 20 days to be taken in
a year on a rolling basis.
Example: During the 2005 year employee took the following sick days
June 4 2005, August 19, 2005, October 23 2005

So, for the year 2006 this employee starts with 17 sick days left and on
June 4 one day is added, on August 19 another day is added, etc.
AND when this employees takes a sick day during the year of 2006 it has to
be deducted

Please tell me there is a formula that will calculate the correct total
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM
how to make a rolling calender where hours roll off after a year Need Support Excel Discussion (Misc queries) 0 February 2nd 06 01:06 AM
Rolling Year in Excel JJC Excel Discussion (Misc queries) 0 June 8th 05 11:21 PM
rolling year in excel JJC Excel Worksheet Functions 1 June 8th 05 12:36 AM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"