Excel Project
 

Using the date of birth, how do I create a field to calculate age in Excel

Excel Project
 

XL has a DateDif function that is undocumented except in XL2K.

This works well for calculating ages in years and/or months and/or days.

It's very well explained in Chip Pearson's web page at:

http://www.cpearson.com/excel/datedif.htm

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Trinidad Cher" <Trinidad wrote in message
...
Using the date of birth, how do I create a field to calculate age in Excel