Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dom Dom is offline
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,047
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dom Dom is offline
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dom Dom is offline
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I set up a machine service schedule omnimack Excel Worksheet Functions 0 June 14th 05 12:50 PM
Slight problem automating Excel in a service someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM
Complex formula help needed Jan Excel Worksheet Functions 0 November 9th 04 03:19 PM
Complex forumula help needed Jan Excel Worksheet Functions 0 November 9th 04 03:09 PM
Need Formula Help Jan Excel Worksheet Functions 0 November 8th 04 10:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"