I want a formula to find age of person
 

I would like to create a formula to take todays date and subtract a birthdate.
K2 being the cell with the date "b-day" in it, such as { =today()-K2 }
to find the age in years and months.

I want a formula to find age of person
 

Aaron, have a look here,

http://www.cpearson.com/excel/datedif.htm#Age
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Aaron" wrote in message
...
I would like to create a formula to take todays date and subtract a
birthdate.
K2 being the cell with the date "b-day" in it, such as { =today()-K2 }
to find the age in years and months.

I want a formula to find age of person
 

Use DATEDIFF - an undocumented function
See details at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Aaron" wrote in message
...
I would like to create a formula to take todays date and subtract a
birthdate.
K2 being the cell with the date "b-day" in it, such as { =today()-K2 }
to find the age in years and months.