D Doug Mc May 2, 2005 #1 If I have the date of birth, how do I calulate the age of a person? Thanks Doug
P Paul B May 2, 2005 #2 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, 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
C Chip Pearson May 2, 2005 #3 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
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
D Doug Mc May 2, 2005 #4 Thanks to BOTH of you! Doug Chip Pearson said: 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 Click to expand...
Thanks to BOTH of you! Doug Chip Pearson said: 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 Click to expand...