Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 46
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
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1,047
Length of Service

hi Dom,

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.

#3
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1
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

#4
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1
Length of Service

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833

#5
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 46
Length of Service

Thanks Marcelo,

I have Excel 2000, and behind the times.

Thanks from Massachusetts

"Marcelo" wrote:

hi Dom,

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.

#6
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 46
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

#7
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1
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

#8
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 35,218
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

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post omnimack Excel Worksheet Functions 0 June 14th 05 12:50 PM someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM Jan Excel Worksheet Functions 0 November 9th 04 03:19 PM Jan Excel Worksheet Functions 0 November 9th 04 03:09 PM Jan Excel Worksheet Functions 0 November 8th 04 10:49 PM

All times are GMT +1. The time now is 09:49 AM.