Hi all. It is time to pay our firms employees 13th Months Bonus (Annual
Benefit). We have paid this bonus last year on Nov 05. Most of our employees
are still working with our company and are eligible for full amount of 13
month bonus which is equal to their last month pay or October 06. (Example:
if an employee gets his/her October 06 salary and it is equal to $500 then
he/she will be eligible for $500 13th month bonus) some of our employees
joined the company later than previous 13th month bonus payment time. for
such employees we prorate their 13th month bonus as (monthly salary/12 * # of
months worked)
I would like to have a column in my tracker that if I put the his hire date,
I should get the # of months worked in another column. Actually I need a
formula to do 12 times logical and return me the exact value. example ( if an
employee's hire date is between January 1 and January 31, it should give me
10 and if it is between 1 February and 28 february it should return me 9
which is the # of months he woked.
Can anybody help me. If you didn't get my explanation well, I am available
to talk to you on my skype ID: daoudfakhry1985 and or my yahoo ID
as well. Thanks for your cooperation.