M Mark Apr 8, 2010 #1 Hi, Trying to get an age cell to self populate based on a cell containing persons date of birth. As always thanks for your help.
Hi, Trying to get an age cell to self populate based on a cell containing persons date of birth. As always thanks for your help.
J JLatham Apr 8, 2010 #2 see http://www.cpearson.com/excel/datetimews.htm scroll down just a few lines and he has a formula for determining age in years, months and days.
see http://www.cpearson.com/excel/datetimews.htm scroll down just a few lines and he has a formula for determining age in years, months and days.
G Gord Dibben Apr 8, 2010 #3 Might be easier to go straight to http://www.cpearson.com/excel/datedif.aspx Gord