hi,
if i suppose the firts day is 2008-10-28 and this day is = 0 year, 0 month, 0 day
the second day is 2012-05-31
note that if you count the difference in number of days you must take into account leap years,
i do not did this for this example, i consider that these days are included in years and months
2007-10-28 0 year, 0 month, 0day
2008-10-28 1 year <-------------- leap year
2009-10-28 2 years
2010-10-28 3 years
2011-10-28 4 years
2011-11-28 1 month
2011-12-28 2 months
2012-01-28 3 months
2012-02-28 4 months <------------- leap year
2012-03-28 5 months
2012-04-28 6 months
2012-05-28 7 months
2012-05-29 1 day
2012-05-30 2 days
2012-05-31 3 days
today (2012-05-31) = 4 years, 7 months, 3 days
=TEXT(RIGHT(YEAR(DATE(DATEDIF(A2,B2,"y"),DATEDIF(A2,B2,"ym"),DATEDIF(A2,B2,"md"))),2),"0")&" year(s) "
&MONTH(DATE(DATEDIF(A2,B2,"y"),DATEDIF(A2,B2,"ym"),DATEDIF(A2,B2,"md")))&" month(s) "
&DAY(DATE(DATEDIF(A2,B2,"y"),DATEDIF(A2,B2,"ym"),DATEDIF(A2,B2,"md")))&" day(s) "
in 6 months = 5 year(s) 1 month(s) 3 day(s)
=TEXT(RIGHT(YEAR(DATE(DATEDIF(A3,B3,"y"),DATEDIF(A3,B3,"ym")+6,DATEDIF(A3,B3,"md"))),2),"0")&" year(s) "
&MONTH(DATE(DATEDIF(A3,B3,"y"),DATEDIF(A3,B3,"ym")+6,DATEDIF(A3,B3,"md")))&" month(s) "
&DAY(DATE(DATEDIF(A3,B3,"y"),DATEDIF(A3,B3,"ym")+6,DATEDIF(A3,B3,"md")))&" day(s) "
--
isabelle
Le 2012-05-30 11:09, Ginabops a écrit :
