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.

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.

Length of Service
 

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

Length of Service
 

See your other post for answer


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562188

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.

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

Length of Service
 

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))


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

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