Excel formula for year calc.

[Bobby]

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]

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

 

[DDM]

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 here: http://www.cpearson.com/excel/datedif.htm (scroll down to
"Calculating a Person's Age").

 

[gls858]

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