Calculate Age from Given Birthdates | Learn Excel with Vaidhvik

Calculate Age from Given Birthdates, Excel, MSOffice,

To calculate age with years, months, and days from a date of birth in Excel using the DATEDIF function, you can use the following formula:

=DATEDIF(B2, TODAY(), "y") & " years, " & DATEDIF(B2, TODAY(), "m") & " months, " & DATEDIF(B2, TODAY(), "d") & " days"

Replace B2 with the cell reference containing the date of birth.

Here's a breakdown of the formula:

1. DATEDIF(B2, TODAY(), "y"): Calculates the number of years between the date of birth and today's date.
2. DATEDIF(B2, TODAY(), "m"): Calculates the number of months between the date of birth and today's date.
3. DATEDIF(B2, TODAY(), "d"): Calculates the number of days between the date of birth and today's date.
4. CONCATENATE: Combines the calculated years, months, and days into a single text string with appropriate labels.

This formula will provide the age in the format "years, months, days". You can customize the format as needed to suit your specific requirements.