How do I calculate the age of a person?
 

If I have the date of birth, how do I calulate the age of a person?

Thanks
Doug

Doug, have a look here for how to do it

http://www.cpearson.com/excel/datedif.htm
--
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

"Doug Mc" wrote in message
...
If I have the date of birth, how do I calulate the age of a person?

Thanks
Doug

You can use the DATEDIF function to do this. See
www.cpearson.com/excel/datedif.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Doug Mc" wrote in
message ...
If I have the date of birth, how do I calulate the age of a
person?

Thanks
Doug

Thanks to BOTH of you!
Doug


"Chip Pearson" wrote in message
...
You can use the DATEDIF function to do this. See
www.cpearson.com/excel/datedif.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Doug Mc" wrote in
message ...
If I have the date of birth, how do I calulate the age of a
person?

Thanks
Doug