Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up an calculation to work out somebody's age from th.
i need to work out somebody's age from their birthday at different points in
time. Please help if you have an existing formula/speadsheet |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
In cell A1 put the birthdate of the person you;r analyzing
In cell B1 put the date of interest In cell C1 put the formula =B1-A1 and then format this cell be doing Right-click Format cells Number tab Custom and type this in the Type: window yy "years, " mm "months" Vaya con Dios, Chuck, CABGx3 "AlexS." wrote in message ... i need to work out somebody's age from their birthday at different points in time. Please help if you have an existing formula/speadsheet |
#4
|
|||
|
|||
Alex
Use the undocumented(except for xl2000)DATEDIF Function. See Chip Pearson's site for details. http://www.cpearson.com/excel/datedif.htm Gord Dibben Excel MVP On Mon, 10 Jan 2005 04:17:02 -0800, AlexS. wrote: i need to work out somebody's age from their birthday at different points in time. Please help if you have an existing formula/speadsheet |
#5
|
|||
|
|||
Hmmm....
I tried your formulas with the dates 12/15/1948 and 11/15/2004. The result is 55 years and 12 months. Should be 11 months. If I change the last date to 12/15/2004 (the 56th birthday), the result is still 55 years and 12 months. Should be 56 years and 0 months. With the 2nd date as 12/16/2004, you get 56 years and 1 month. The correct answer is 56 years and 1 day. Note that the months will always be displayed as 1 through 12, where as the correct range must be 0 through 11. But even if you could somehow decrement the month number, the formula would only be accurate for a person born on January 1 of a leap year. Your logic is to calculate the number of days the person has lived, then translate that into months and years by showing the calendar year and month for a person who has lived that number of days and was born on Jan 1, 1900 (Excel incorrectly treats 1900 as a leap year). For a person born on any other day of the year, the month will not change on the correct day. For a person born in January, the age in months changes after 31 days and changes again after another 28 (or 29) days. For a person born in June, it changes after 30 days, and again after 31 days. On Mon, 10 Jan 2005 07:37:33 -0500, "CLR" wrote: In cell A1 put the birthdate of the person you;r analyzing In cell B1 put the date of interest In cell C1 put the formula =B1-A1 and then format this cell be doing Right-click Format cells Number tab Custom and type this in the Type: window yy "years, " mm "months" Vaya con Dios, Chuck, CABGx3 "AlexS." wrote in message ... i need to work out somebody's age from their birthday at different points in time. Please help if you have an existing formula/speadsheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Service work order | Charts and Charting in Excel | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Updating Automatic links doesn't work with arrays | Excel Discussion (Misc queries) | |||
Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |