Age Calculation

B

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.
 
N

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.
 
G

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
 
F

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"
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top