Age calculation
 

Hi all,

I am trying to get a formula that will calculate someones age from
their Date of birth, is this possible.

Cheers


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=523477

Age calculation
 

IF DOB is in A1, enter following formula in B2:
=YEAR(TODAY()-A1)-1900
and format it standard or number

HTH
--
AP

"Clash" a écrit dans le
message de ...

Hi all,

I am trying to get a formula that will calculate someones age from
their Date of birth, is this possible.

Cheers


--
Clash
------------------------------------------------------------------------
Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=523477

Age calculation
 

Clash wrote

I am trying to get a formula that will calculate someones age from
their Date of birth, is this possible.

The most frequently suggested way is:
DATEDIF(A1, TODAY(), "y")

--
David

Age calculation
 

Hello,
I can get the Ardus Petus to work very well, but I can't seem to get
the David formula ...DATEDIF(A1, TODAY(), "y")... to work. It looks
like there may be a space between the ..first comma and today... and
also a space between the ...second comma and the first quotation
mark...
Irregardless, I can't get it to work with or without a space.
I have tried formating my formula cell to TEXT, then to NUMBER, and
then to GENERAL.
I can't get it to go.
I also have put an equal sign at the first and that didn't help. Could
the formula be incorrect or am I doing something wrong?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=523477

Age calculation
 

What specifically do you mean by "can't get it to work"? Do you
receive an error value in the cell? An unexpected result? Please
be specific.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"lsmft"
wrote in message
...

Hello,
I can get the Ardus Petus to work very well, but I can't seem
to get
the David formula ...DATEDIF(A1, TODAY(), "y")... to work. It
looks
like there may be a space between the ..first comma and
today... and
also a space between the ...second comma and the first
quotation
mark...
Irregardless, I can't get it to work with or without a space.
I have tried formating my formula cell to TEXT, then to NUMBER,
and
then to GENERAL.
I can't get it to go.
I also have put an equal sign at the first and that didn't
help. Could
the formula be incorrect or am I doing something wrong?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread:
http://www.excelforum.com/showthread...hreadid=523477

Age calculation
 

Found my error, it's working fine now.
Thanks much and have a wonderful day


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=523477