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

1 comments:

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:

http://alvarogomezcastro.over-blog.es

Greetings from Santa Marta, Colombia.

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites