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

I've used Chip Pearson's excellent site for this. Try
http://cpearson.com/excel/datedif.htm

Steve

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." <AlexS.@discussions.microsoft.com> wrote in message
news:41B78454-D856-4CDE-8319-4042E5B35BA4@microsoft.com...
> 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

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" <croberts@tampabay.rr.com> 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." <AlexS.@discussions.microsoft.com> wrote in message
>news:41B78454-D856-4CDE-8319-4042E5B35BA4@microsoft.com...
>> 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
>

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. <AlexS.@discussions.microsoft.com>
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