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.

Hi
With Base Date of 01 Oct 06 in cell A1, and start dates in B1, October
Salary in C1,
enter in D1
=(DATEDIF(B1,$A$1,"ym")+1)/12*C1
will provide the amount to pay for 13 month Bonus
Copy down column D for the full list of Employees

Change ranges to suit

--
Regards

Roger Govier


"Daoud Fakhry" wrote in message
...
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.