It’s just easier to keep both dates together if you’re tracking multiple ages.ģ. Now, enter today’s date into the cell next to your first cell. In our example, we’re using Tom Hanks, and his date of birth is in cell A2.Ģ.
To get started, enter the date of a person’s birth into your first cell. This is a pretty simple three-column task. People may not always appreciate that you have a spreadsheet of their exact ages, but it can definitely have its benefits. Read on for tips on how to calculate age in Excel. It’s not as hard as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. A classic example is working out someone’s age. Finding the exact difference between two dates in Excel may not be a popular use, but it can be a lot of fun.
