Nokia C5-00.2 Pc Suite Software on this page. In this post, you will learn How To Calculate Age From Date of Birth In Excel by creating formula with DATEDIF and TODAY. Age Calculation in Excel - How to Calculate Age in Excel up to the Current Date or to a Specified Date. How to Calculate Age on Excel. Tells DATEDIF to calculate the difference between the date in cell B2.,'Y') where A2 was the cell with the birth date.

Officesuite Pro 7 Activation Key. Microsoft Excel provides a function that displays a person's age based on his date of birth. In your business, this function can help you keep track of your workers' ages in a spreadsheet; you'll need to know this information, for example, if you are shopping for new health insurance coverage for your company. Every time you open the spreadsheet, Excel will update the Age cells based on the current date. To calculate the age, the DATEDIF function, set to check year, determines the number of years between the date in the DOB cell and the current date.

Using a combination of and the date of birth, you can easily calculate age in Excel. You can either calculate the age till the current date or between the specified period of time. The technique shown here can also be used in other situations such as calculating the duration of a project or the tenure of the service. How to Calculate Age in Excel In this tutorial, you’ll learn how to calculate age in Excel in: • The number of years elapsed till the specified date. A Streetcar Named Desire 1995. • The number of Years, Months, and Days elapsed till the specified date.