How to Calculate Age in years, months and days from date of birth in Excel - Office 365

preview_player
Показать описание
Sometimes you might need to calculate the exact age meaning how many years, months and days from date of birth to current date. You can use DATEDIF function to calculate the exact age.

To download the practice excel file please click on the link below
Рекомендации по теме
Комментарии
Автор

do we have similar formula in Power BI

shivameduri
Автор

In case of DOB column empty it is showing the age 122 Years, 1 Months, 2 Days. Please suggest how to remove this error or confirm the age column be empty as DOB column.

saurabhgupta
Автор

WHEN I ENTER THE FORMULAE ITS GIVES #VALUE ERROR PLEASE LET US KNOW ABOUT THE ERROR THANKYOU

directorateofntfp