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
<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>
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>