I need to convert a date of birth to age. However, I need to base it
on Sept 1, 2011. I need to know how old (years only) that person is
on that date. Does anyone know how to do this. Why is September 1,
2011 so important. It allows me to determine if they are eligible(too
young or too old) to play a sport.

Hi,

Am Wed, 7 Sep 2011 12:25:11 -0700 (PDT) schrieb D G:

> I need to convert a date of birth to age. However, I need to base it
> on Sept 1, 2011. I need to know how old (years only) that person is
> on that date. Does anyone know how to do this. Why is September 1,
> 2011 so important. It allows me to determine if they are eligible(too
> young or too old) to play a sport.

date of birth in A1, Sept 1, 2011 in B1 then:
=DATEDIF(A1,B1,"Y")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

What about
enter this in C1
=($B$1-A1)/365.25

B1 is 1-9-11
A1 is date of birth
change format in column C to number with 1 decimal place.


"D G" <(E-Mail Removed)> wrote in message
news:4e3bdf03-9e91-4283-8dfa-(E-Mail Removed)...
>I need to convert a date of birth to age. However, I need to base it
> on Sept 1, 2011. I need to know how old (years only) that person is
> on that date. Does anyone know how to do this. Why is September 1,
> 2011 so important. It allows me to determine if they are eligible(too
> young or too old) to play a sport.

Roger Dodger,
If you change the resulting cell to two (2) decimal places, in the cell
format, it would be better. Or better yet, use the "rundown function such
as:
" =rounddown(($B$1-A1)/365.25,0) " (w/o quotes) .

Place minimum age in Cell C1 and using:
" =If(rounddown(($B$1-A1)/365.25,0)<$C$1."InEligible",Eligible) " (w/o
quotes) .

--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))


"Roger Dodger" <(E-Mail Removed)> wrote in message
news:aNjdq.2615$(E-Mail Removed)...
What about
enter this in C1
=($B$1-A1)/365.25

B1 is 1-9-11
A1 is date of birth
change format in column C to number with 1 decimal place.


"D G" <(E-Mail Removed)> wrote in message
news:4e3bdf03-9e91-4283-8dfa-(E-Mail Removed)...
>I need to convert a date of birth to age. However, I need to base it
> on Sept 1, 2011. I need to know how old (years only) that person is
> on that date. Does anyone know how to do this. Why is September 1,
> 2011 so important. It allows me to determine if they are eligible(too
> young or too old) to play a sport.