Calculating dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that lists separate periods of employment. Ex:
03/29/84 05/13/84
05/14/84 09/18/85
09/19/85 01/31/96
I'm using the following formula to calculate each row each in a separate
column:
Years Months
Days
=YEAR(B3)-YEAR(A3), =(MOD((B3-A3),365.25))/30.4, =DAY(B3-A3)

What formula would I use to calulate the cumulative total of all of the rows
based on the output received for years, months and days?
 
Tanya,

For your months and days you would be better to use the DATEDIF function as
in =DATEDIF(A3,B3,"ym") for months and =DATEDIF(A3,B3,"md") for days. If
your dates are consecutive then you can combine them all for a total as in :

=DATEDIF(A3,B5,"y")&" Years "&DATEDIF(A3,B5,"ym")&" Months
"&DATEDIF(A3,B5,"md")&" days"

which will return "11 Years 10 Months 2 Days"

You can find more info on DATEDIF in

http://www.cpearson.com/excel/datedif.htm

HTH

Sandy
 
Back
Top