Wednesday, February 9, 2011

For Birth Dates After 1900 Excel Function

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/

Stumble This Fav This With Technorati Add To Del.icio.us Digg This Add To Reddit Add To Facebook Add To Yahoo

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites