Age calculation

[Clash]

Hi all,

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

Cheer

 

[Ardus Petus]

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

HTH

 

[David]

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

 

[lsmft]

Hello,
I can get the Ardus Petus to work very well, but I can't seem to ge
the David formula ...DATEDIF(A1, TODAY(), "y")... to work. It look
like there may be a space between the ..first comma and today... an
also a space between the ...second comma and the first quotatio
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, an
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. Coul
the formula be incorrect or am I doing something wrong

 

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[lsmft]

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