# Best Solution to calculated the sum of years, months, days

#### realman07

##### New Member
dears
this is the most corrective solution to find sum of years, months, days
note, some times you may be find a shortage of 1 or 2 days in answers because of datedif function did not identifying the leap year
but i think this is the best solution
Also, how can i upload an excel file with my post to give you the solution(formulas)

thxs
 Start Finish Total​​ Start Finish Total​ T. Days D. V. T. Month M. V. T. Years Days Month Years Description 01-01-1974 31-12-1999 25, 11, 30 01-01-2002 31-12-2014 12, 11, 30 60 1 23 1 37 30 11 38 38 Yrs, 11 Months, 30 Days 28-02-1986 18-06-2000 14, 03, 21 16-01-2001 03-04-2014 13, 02, 18 39 1 6 0 27 9 6 27 27 Yrs, 6 Months, 9 Days 15-12-1998 16-12-2004 06, 00, 01 20-07-2009 03-04-2014 04, 08, 14 15 0 8 0 10 15 8 10 10 Yrs, 8 Months, 15 Days 04-10-1988 31-10-2009 21, 00, 27 05-12-2011 03-04-2014 02, 03, 29 56 1 4 0 23 26 4 23 23 Yrs, 4 Months, 26 Days 02-07-1981 31-07-2001 20, 00, 29 30-10-2006 03-04-2014 07, 05, 04 33 1 6 0 27 3 6 27 27 Yrs, 6 Months, 3 Days 06-01-1976 31-12-1998 22, 11, 25 02-08-2004 03-04-2014 09, 08, 01 26 0 19 1 31 26 7 32 32 Yrs, 7 Months, 26 Days 01-01-1974 31-03-1999 25, 02, 30 01-01-2002 30-12-2014 12, 11, 29 59 1 14 1 37 29 2 38 38 Yrs, 2 Months, 29 Days 30-06-1992 01-03-2016 23, 08, 00 00, 00, 00 0 0 8 0 23 0 8 23 23 Yrs, 8 Months, 0 Days

<COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" span=2 width=103><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" span=2 width=107><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 365" width=10><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" width=32><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" width=32><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 365" width=10><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" span=3 width=58><COL style="WIDTH: 163pt; mso-width-source: userset; mso-width-alt: 7936" width=217><TBODY>
</TBODY>

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Replies
1
Views
185
Replies
11
Views
552
Replies
2
Views
634
Replies
2
Views
189
Replies
4
Views
1K

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

1,151,612
Messages
5,765,419
Members
425,286
Latest member
CazzaBabes

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back