+ Reply to Thread
Results 1 to 11 of 11

Length of Service

  1. #1
    Dom
    Guest

    Length of Service

    I would like to create a formula that would calculate the length of a
    person's employment, i.e. hired 8/14/94 till today, for example. Any Ideas
    will be greatfully accepted.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try this

    =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"

  3. #3
    Marcelo
    Guest

    RE: Length of Service

    hi Dom,

    try to use =DATADIF

    look the help!

    hth
    regards from Brazil
    Marcelo

    "Dom" escreveu:

    > I would like to create a formula that would calculate the length of a
    > person's employment, i.e. hired 8/14/94 till today, for example. Any Ideas
    > will be greatfully accepted.


  4. #4
    Dom
    Guest

    RE: Length of Service

    Thanks Marcelo,

    I have Excel 2000, and behind the times.

    Thanks from Massachusetts

    "Marcelo" wrote:

    > hi Dom,
    >
    > try to use =DATADIF
    >
    > look the help!
    >
    > hth
    > regards from Brazil
    > Marcelo
    >
    > "Dom" escreveu:
    >
    > > I would like to create a formula that would calculate the length of a
    > > person's employment, i.e. hired 8/14/94 till today, for example. Any Ideas
    > > will be greatfully accepted.


  5. #5
    Dom
    Guest

    Re: Length of Service

    Hi,

    I have excel 2000, ain't there, need to upgrade.

    Thanx for trying.

    "VBA Noob" wrote:

    >
    > Try this
    >
    > =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
    > Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
    >
    >
    > --
    > VBA Noob
    > ------------------------------------------------------------------------
    > VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
    > View this thread: http://www.excelforum.com/showthread...hreadid=562193
    >
    >


  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    This gets you the year if that helps

    =IF(MONTH(TODAY())>MONTH(A1),YEAR(TODAY())-YEAR(A1),IF(AND(MONTH(TODAY())=MONTH(A1),DAY(TODAY())>=DAY(A1)),A1YEAR(TODAY())-YEAR(A1),(YEAR(TODAY())-YEAR(A1))-1))

  7. #7
    Dave Peterson
    Guest

    Re: Length of Service

    =datedif() is documented in xl2k's help (the only version of excel where it IS
    documented, actually). But all versions of excel have that function.

    Chip Pearson has some very nice notes at:
    http://www.cpearson.com/excel/datedif.htm

    Dom wrote:
    >
    > Hi,
    >
    > I have excel 2000, ain't there, need to upgrade.
    >
    > Thanx for trying.
    >
    > "VBA Noob" wrote:
    >
    > >
    > > Try this
    > >
    > > =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
    > > Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
    > >
    > >
    > > --
    > > VBA Noob
    > > ------------------------------------------------------------------------
    > > VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
    > > View this thread: http://www.excelforum.com/showthread...hreadid=562193
    > >
    > >


    --

    Dave Peterson

  8. #8
    Dave Peterson
    Guest

    Re: Length of Service

    =datedif() is documented in xl2k's help (the only version of excel where it IS
    documented, actually). But all versions of excel have that function.

    Chip Pearson has some very nice notes at:
    http://www.cpearson.com/excel/datedif.htm

    Dom wrote:
    >
    > Hi,
    >
    > I have excel 2000, ain't there, need to upgrade.
    >
    > Thanx for trying.
    >
    > "VBA Noob" wrote:
    >
    > >
    > > Try this
    > >
    > > =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
    > > Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
    > >
    > >
    > > --
    > > VBA Noob
    > > ------------------------------------------------------------------------
    > > VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
    > > View this thread: http://www.excelforum.com/showthread...hreadid=562193
    > >
    > >


    --

    Dave Peterson

  9. #9
    Dave Peterson
    Guest

    Re: Length of Service

    =datedif() is documented in xl2k's help (the only version of excel where it IS
    documented, actually). But all versions of excel have that function.

    Chip Pearson has some very nice notes at:
    http://www.cpearson.com/excel/datedif.htm

    Dom wrote:
    >
    > Hi,
    >
    > I have excel 2000, ain't there, need to upgrade.
    >
    > Thanx for trying.
    >
    > "VBA Noob" wrote:
    >
    > >
    > > Try this
    > >
    > > =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
    > > Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
    > >
    > >
    > > --
    > > VBA Noob
    > > ------------------------------------------------------------------------
    > > VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
    > > View this thread: http://www.excelforum.com/showthread...hreadid=562193
    > >
    > >


    --

    Dave Peterson

  10. #10
    Dave Peterson
    Guest

    Re: Length of Service

    =datedif() is documented in xl2k's help (the only version of excel where it IS
    documented, actually). But all versions of excel have that function.

    Chip Pearson has some very nice notes at:
    http://www.cpearson.com/excel/datedif.htm

    Dom wrote:
    >
    > Hi,
    >
    > I have excel 2000, ain't there, need to upgrade.
    >
    > Thanx for trying.
    >
    > "VBA Noob" wrote:
    >
    > >
    > > Try this
    > >
    > > =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
    > > Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
    > >
    > >
    > > --
    > > VBA Noob
    > > ------------------------------------------------------------------------
    > > VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
    > > View this thread: http://www.excelforum.com/showthread...hreadid=562193
    > >
    > >


    --

    Dave Peterson

  11. #11
    Dave Peterson
    Guest

    Re: Length of Service

    =datedif() is documented in xl2k's help (the only version of excel where it IS
    documented, actually). But all versions of excel have that function.

    Chip Pearson has some very nice notes at:
    http://www.cpearson.com/excel/datedif.htm

    Dom wrote:
    >
    > Hi,
    >
    > I have excel 2000, ain't there, need to upgrade.
    >
    > Thanx for trying.
    >
    > "VBA Noob" wrote:
    >
    > >
    > > Try this
    > >
    > > =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
    > > Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
    > >
    > >
    > > --
    > > VBA Noob
    > > ------------------------------------------------------------------------
    > > VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
    > > View this thread: http://www.excelforum.com/showthread...hreadid=562193
    > >
    > >


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1