Excel formula for year calc.

  • Thread starter Thread starter Bobby
  • Start date Start date
B

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
 
-----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
.
Click to expand...
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
 
Sai said:
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
Click to expand...
Just tried this I think it should be datedif not dateif

gls858
 
Back
Top