Calulating future Age
 

How do I formulate an age and what it would be in 6 months, 12 months, and 18 months?

Which version of Excel are you using?
If 2003, do you have the Analysis Toolpak add in installed?

To do what you've asked above with any ease you will need the =EOMONTH() formula available to you and for that you need Excel 2007 or later or the Analysis Toolpak.

Calulating future Age
 

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(A 2,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"),D ATEDIF(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(A 3,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 :
How do I formulate an age and what it would be in 6 months, 12 months,
and 18 months?