Calculating current ages from a list of birth dates can be performed in a number of ways -- some are more accurate than others. This video describes using YEARFRAC with ROUNDDOWN or INT to accomplish this task.
Visit http://www.excel4business.com/videos/excel-yearfrac-function.php for additional information on this video.
The "Excel Basics" series of videos has been created by Excel4Business' expert consultants.
thanks for the well explained vid. great for my assignment :)
69sico96 6 months ago