Browse » Home
Tuesday, May 17, 2011
How to Calculate Age From Date of Birth in Excel
1. Write the date of birth in cell A1. For example, write 2/9/1967.
2. Type the TODAY function in cell B1. The TODAY function is:
=TODAY()
This will always return the current date.
3. Type the following into cell C3:
=(B1-A1)/365.25.
The person's age in years will appear once you hit 'Enter.'