Date calculations

[Kathy Goodale]

I am trying to write 2 calcs to give me the following LOS
(length of service) results as in the examples below. For
example, how many months has an employee worked if today
is 5/31/2003 and they started working on 9/21/2000. Also,
how many Years, Months, days?

Sample data:
Current Date: 05/31/2003
Date to calc from: 9/20/2000
LOS in Months: 32
LOS in Years: 2Y-8M-11D

Current Date: 5/31/2003
Date to calc from: 3/23/2000
LOS in Months: 38
LOS in Years: 3Y-2M-8D

Current Date: 5/31/2003
Date to calc from: 07/06/2004
LOS in Months: 58
LOS in Years: 4Y-10M-25D

 

[Frank Kabel]

Hi
use DATEDIF for this.
See: http://www.cpearson.com/excel/datedif.htm

 

[Don]

Hi Kathy,

Try this, I think with a little tweaking it'll do
everything you want. Starting date in A1 (or adjust
formula to the cell you have it entered), ending date in
A2 (or again adjust to the cell you have it entered in):

=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym")
& " months, " & DATEDIF(A1,A2,"md") & " days"

HTH

Don