How To Calculate Age in Excel DDMMYYYY (2023)

#microsoftexcel To calculate age in Excel based on a date of birth in the format DDMMYYYY, you can use a combination of functions, including TODAY, YEAR, MONTH, DAY, and DATE. Follow these steps:

1. In an Excel cell, enter the date of birth in the format DDMMYYYY. For example, if the date of birth is 15th May 1985, enter it as 15051985.

2. In another cell, enter the following formula:
```
=INT((TODAY()-DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2)))/365.25)
```
Replace A1 with the cell reference containing the date of birth.

3. Press Enter to calculate the formula.

The formula subtracts the date of birth from the current date (TODAY function) and divides it by 365.25 to account for leap years. The INT function is used to round down the result to the nearest whole number, giving you the age in years.

The result will be the calculated age based on the provided date of birth. You can format the cell with the formula as a number to remove any decimal places or apply other formatting as desired.

Note: Keep in mind that this method assumes that the date of birth is in the correct format and does not account for potential input errors.

[astasigrun]

If i want to do this formula but only have 08/18/94 - how can alter the formula for that?

[justjonzing]

this one worked. the ones on google and Microsoft didn't.