Accrual Vacation Schedule to Forecast/Note the year Employee Vacation 1-4 weeks is eligibl

Hi Jackie,

Take a look at the attached workbook and see if it does what you want.

Can you give me some more information about what you mean by:

and alerts if possible for the upcoming eligible vacation

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you for your submission reply. The attached completed spreadsheet is what I completed so far, with the help of this forum.

1.) I believe your formulas were different than mine, can you tell me if its relative?

2.) Do you know how I could add a column that will automatically "highlight" alert me by auto
fill/highlighting the cells when they are eligible for the anniversary date. For example I would have liked to add a column
which shows, the formulas that says the weeks they are eligible and the date 1/1/14 is the date employees can request, or
cash in the vacation days, and how many days.

I tried to reflect that in the worksheet but it wasn't my best work. Any advice is welcome. Thank you to everybody in advance.

Hi again,

Take a look at the attached workbook and see if it does what you want.

It includes a "Recruitment Date Generator" so that you can easily experiment with different dates to check that the workbook behaves as you expect it to. It also allows you to specify an "Advance Warning Period" (e.g. four weeks) which will highlight any employee whose annual leave entitlement will increase within that period.

Hope this helps - please let me know how you get on.

Regards,

Greg M