Formula for Job Tenure Needed (in Months)

Thanks:  0
Likes:  0

# Thread: Formula for Job Tenure Needed (in Months)

1. ## Formula for Job Tenure Needed (in Months)

In Cell A2 have Employee I Have Employee Name
In Cell B2 I have Employee Date of joining
In cell C2 I want ta formulas to calculate the employee Job tenure

for example in B2 i Have 16-01-1974 in cell c2 I wnatto calculate the emplyees tenure .

Regards

2. We can estimate it with something like

=INT((B1-A1)/(365/12))

which will give you the months rounded down.

3. ## Re: Formula for Job Tenure Needed (in Months)

Originally Posted by Kamal Subhani
In Cell A2 have Employee I Have Employee Name
In Cell B2 I have Employee Date of joining
In cell C2 I want ta formulas to calculate the employee Job tenure

for example in B2 i Have 16-01-1974 in cell c2 I wnatto calculate the emplyees tenure .

Regards
This formula calculates the number of years to current and converts to months then adds in the months that have passed in the current year. The cell must be formatted for General NOT dates.

=(YEAR(NOW())-YEAR(B1))*12+(MONTH(NOW()-B1)) This gives tenure in months (384). If you want in years and months try this.

=(YEAR(NOW())-YEAR(B1))&" YRS "&(MONTH(NOW()-B1))&" MONS "

Answer = 32 YRS 4 MONS

4. ## Re: Formula for Job Tenure Needed (in Months)

I've seen this used to calculate number of days, between dates.
Copy D9 down as far as required.

Hope this works

******** ******************** ************************************************************************>
 Microsoft Excel - Lotto Draw 5 and 6.xls ___Running: xl2002 XP : OS = Windows Windows 2000
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 D9 =

A
B
C
D
8
EmployeeHireDateContractDateTenure
9
Employee101/Apr/200419/Apr/200419.00
 Sheet1

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

5. num complete months
=DATEDIF(E128,TODAY(),"m")

num months rounded up
=DATEDIF(E128,TODAY(),"m")+(DATEDIF(E128,TODAY(),"md")>=16)

6. ## Re: Formula for Job Tenure Needed (in Months)

Thanks all

=DATEDIF(E128,TODAY(),"m")

That worked fine

Regards

Kamal Subhani

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•