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

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" <[email protected]> wrote in
message news:%[email protected]...
> 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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
> message news:%[email protected]...
> > If I have the date of birth, how do I calulate the age of a
> > person?
> >
> > Thanks
> > Doug
> >
> >
>
>