S Simon Chang Nov 6, 2005 #1 How to write a formula to get an exact age of a person and etc (year,month,day) with date given. Thank in advance.
How to write a formula to get an exact age of a person and etc (year,month,day) with date given. Thank in advance.
B Bob Phillips Nov 6, 2005 #2 See http://www.cpearson.com/excel/datedif.htm down a little -- HTH RP (remove nothere from the email address if mailing direct)
See http://www.cpearson.com/excel/datedif.htm down a little -- HTH RP (remove nothere from the email address if mailing direct)
S Simon Chang Nov 6, 2005 #3 A big thanks for the respond. Bob Phillips said: See http://www.cpearson.com/excel/datedif.htm down a little -- HTH RP (remove nothere from the email address if mailing direct) Click to expand...
A big thanks for the respond. Bob Phillips said: See http://www.cpearson.com/excel/datedif.htm down a little -- HTH RP (remove nothere from the email address if mailing direct) Click to expand...