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.


Stumble This Fav This With Technorati Add To Digg This Add To Reddit Add To Facebook Add To Yahoo


Hi, Excellent blog. I am an educator and I am constantly gathering information, I invite you to visit the mine on philosophy, literature and film. If you want to know, the address is:

Greetings from Santa Marta, Colombia.

Post a Comment

Related Posts Plugin for WordPress, Blogger...


Twitter Delicious Facebook Digg Stumbleupon Favorites