Excel formula for year calc.

I'm new to excel, I have all the information set up on
excel with name, address, date of birth, etc. what I need
is the formula to calculate age in excel. I have no idea
how to figure this out. Any help would be appreciated.

Thanks,

Bobby

-----Original Message-----
I'm new to excel, I have all the information set up on
excel with name, address, date of birth, etc. what I
need
is the formula to calculate age in excel. I have no
idea
how to figure this out. Any help would be appreciated.

Thanks,

Bobby
.
Hi,
Try this on the cell where you want to display the
age, type in =dateif("A1",today(),"Y").

"A1" is where you have your date of birth info.

Sai S. Vy

Bobby, the DATEDIF worksheet function is just what you need. See Sai S. Vy's
post for a simple example of its use. For more information on this function,
look he http://www.cpearson.com/excel/datedif.htm (scroll down to
"Calculating a Person's Age").
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Bobby" wrote in message
...
I'm new to excel, I have all the information set up on
excel with name, address, date of birth, etc. what I need
is the formula to calculate age in excel. I have no idea
how to figure this out. Any help would be appreciated.

Thanks,

Bobby

Sai S. Vy - IS150 wrote:

-----Original Message-----
I'm new to excel, I have all the information set up on
excel with name, address, date of birth, etc. what I

need

is the formula to calculate age in excel. I have no

idea

how to figure this out. Any help would be appreciated.

Thanks,

Bobby
.

Hi,
Try this on the cell where you want to display the
age, type in =dateif("A1",today(),"Y").

"A1" is where you have your date of birth info.

Sai S. Vy


Just tried this I think it should be datedif not dateif

gls858