formula for age based on date of birth

[liz h]

This is probably so easy I'm going to be embarrassed for
asking, but let's say I've got column A where I have to
enter Date of Birth and in column B I need age. What is
the formula I should put in column B?

Thanks,
Liz

 

[Paul B]

Liz, have a look here, http://www.cpearson.com/excel/datedif.htm#Age
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Liz]

You're the greatest, Paul. Thanks!

-----Original Message-----
Liz, have a look here, http://www.cpearson.com/excel/datedif.htm#Age
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **




.