Using the date of birth, how do I create a field to calculate age in Excel
T Trinidad Cher Dec 4, 2005 #1 Using the date of birth, how do I create a field to calculate age in Excel
R Ragdyer Dec 4, 2005 #2 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
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
