formula required!

[cplusHR]

Please I want some assistance with certain formulas.

J2 Used Vacation Days.
E2 Unused Vacation from Two Years Ago
F2 Unused Vacation from Last Year
H2 Remaining Vacation Days (this year)

I have Starting date of Employee in C2
Date till today in D2

The Used Vacation Days are the ones taken of course and I do not need a formula for that. Since it will generate from total of dates total taken.

C2 does not require a formula since it is entered manually. As for D2 the formula is ;
=Today ()

I require the formula for E2, F2, and H2. If you want more information to assist me I would be thankful.

Thank you in advance.

 

[Robert Mika]

Could you post some data and tell what's the allowance of Holiday days per yaer?

 

[cplusHR]

Could you post some data and tell what's the allowance of Holiday days per yaer?

Allowance of Holiday days per year as follows;

Starting from less than a year does not have any days.
Year one till three - 15 days
Year four till six - 17 days
Year seven till ten - 19 days
Year Eleven and plus - 21 days.

I will give you link to the upload of the file that I am working on.

http://www.box.net/shared/p69akdgmjtc8o28jyozc

Thanks

 

[cplusHR]

I wont be using;

E2 Unused Vacation from Two Years Ago

 

[cplusHR]

Please I need some formula to sort this out.

 

[cplusHR]

I figure it out. No need for help anymore. Thanks.