Age Calculation

[Bob]

I am trying to create a spreadsheet for Little League
baseball that calculates the players age on a specific
date. For example given a birthdate we need to know the
age in years of the 31st of July 2004.

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/datedif.htm#Age

 

[Norman Harker]

Hi Bob!

Use:
=DATEDIF(A1,"31-Jul-2004","y")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Frank:

Thanks and it works great. The only problem is that I
need the calculation to occur for a date in the future.
For example, if my birthdate is 07-12-1992, how old will
I be on July 31, 2004.

Thanks

Bob

 

[Frank Kabel]

Hi
if A1 stores your birthdate and A2 the date for which you want to
calculate your age change the formula as follows:
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"

 

[JE McGimpsey]

You can still use DateDif:

=DATEDIF("07-12-1992","07-31-04","y")

 

[Norman Harker]

Hi Bob!

Private thanks acknowledged!

Just a word of caution! I hard coded the 31-Jul-2004 into the
function. This is not recommended because:

1. It's less easy to edit the End_date
2. Conversion of date strings depends upon the Regional Settings and
double digit year interpretation setting of the computer. The form I
used was one of the few forms that are recognized by all English
language (FAOD inc. USA) versions of Excel. If you want to cover
non-English language versions use "2004-07-31"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Rusty Shackelford]

How would you do that for the current date?

You can still use DateDif:

=DATEDIF("07-12-1992","07-31-04","y")

 

[JE McGimpsey]

Replace the second date with TODAY()