Basically, I need to create a spreadsheet showing number of accumulated

vacation days for an employee based on the number of days they accrue

per day per year.

We created a formula that basically used the current date (of the day

you actually accessed the spreadsheet) to calculate the number of days

(with like 2 decimal places) the employee had accrued to date.

This is the info we used to generate the number:

Anniversary date

Days accrued for year 1, 2, 3, 4, 5...

Less than A year does not have any days.

Year one - 15 days

Year two - 15 days

Year three - 15 days

Year four - 17 days

Year five - 17 days

Year six - 17 days

Year seven - 19 days

Year eight - 19 days

Year nine - 19 days

Year ten - 19 days

Year Eleven - 21 days

Further more is going to be 21 Days.

Also taking in consideration that any days not used the previous year,

will roll over to the next year. The limit is only within 2 years, after that the days will be over.

Lets Say, in Main Sheet I will have as Follows;

**Employee Number**

__A2__**Employee**

__B2__**Start Date**

__C2____Today ()__

**D2**__Accumulated Vacation Days__

**E2**__Remaining Vacation Days__

**F2**__Vacation Available__

**G2**__Unused Vacation from last year__

**H2**The Second sheet, is to calculate the vacation days that are being taken.

Or having individual sheet for each employee since there are only 25 staff max.

If you need any further clarification toward this matter, I would be glad to let you know to assist with this nightmare that I am having.

Any Help would be apprciated,can someone please help me with this?

Thank you.