To calculate the age of a person on date since their birthdate:=INT((date-birthdate)Applies To:MS Excel 2003,MS Excel 2007,MS Excel 2010
To figure their age as of today, date can be replaced with a function like TODAY() or NOW(). The INT() function is used to return only the number of complete years.
Publisher: http://excel-formulas.blogspot.com/
Wednesday, February 9, 2011
0 comments:
Post a Comment