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.
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.
Try this
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
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.
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.
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
>
>
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))
=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
=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
=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
=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
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks