Results 1 to 6 of 6

Formula for Job Tenure Needed (in Months)

This is a discussion on Formula for Job Tenure Needed (in Months) within the Excel Questions forums, part of the Question Forums category; In Cell A2 have Employee I Have Employee Name In Cell B2 I have Employee Date of joining In cell ...

  1. #1
    Board Regular
    Join Date
    Jan 2004
    Posts
    146

    Default 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. #2
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    We can estimate it with something like

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

    which will give you the months rounded down.

  3. #3
    Board Regular
    Join Date
    Dec 2002
    Location
    Tempe, Arizona
    Posts
    323

    Default Re: Formula for Job Tenure Needed (in Months)

    Quote 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
    Started building macros in Lotus 123, then Quattro Pro and now program in Excel VBA.

    Gaynard Nelson

    The race is not always to the swift
    But to those who keep on running

  4. #4
    Board Regular
    Join Date
    Jan 2004
    Posts
    307

    Default 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
    =

    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. #5
    Board Regular
    Join Date
    Dec 2002
    Posts
    346

    Default

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

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

  6. #6
    Board Regular
    Join Date
    Jan 2004
    Posts
    146

    Default Re: Formula for Job Tenure Needed (in Months)

    Thanks all

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


    That worked fine


    Regards


    Kamal Subhani

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com