Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I set up a machine service schedule | Excel Worksheet Functions | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Complex formula help needed | Excel Worksheet Functions | |||
Complex forumula help needed | Excel Worksheet Functions | |||
Need Formula Help | Excel Worksheet Functions |