How can I calculate age on Excel by using formula?
How can I calculate age on Excel by using formula?
To calculate the age of a person in Excel, use the DATEDIF function and the TODAY function. The DATEDIF function has three arguments. … Note: fill in "y" for the third argument to get the number of complete years between the date of birth and today's date.