Formula for Job Tenure Needed (in Months)

[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

 

[DRJ]

We can estimate it with something like

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

which will give you the months rounded down.

 

[gaynard_nelson]

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

 

[adulted]

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

Hope this works

Lotto Draw 5 and 6.xls
	A	B	C	D
8	Employee	HireDate	ContractDate	Tenure
9	Employee1	01/Apr/2004	19/Apr/2004	19.00
Sheet1

 

[2rrs]

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

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

 

[Kamal Subhani]

Thanks all

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


That worked fine


Regards


Kamal Subhani