Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calulating future Age
How do I formulate an age and what it would be in 6 months, 12 months, and 18 months?
|
#2
|
|||
|
|||
Quote:
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with calulating Null fields | Excel Worksheet Functions | |||
Calulating week # & Day # | Excel Worksheet Functions | |||
reducing Calulating time | Excel Discussion (Misc queries) | |||
Calulating Age Formula | Excel Worksheet Functions | |||
Calulating the last sayurday of a week using vba | Excel Programming |