How to calculate age from date of birth in excel 2007 or 2010?

preview_player
Показать описание
Formula to Calculate Present Age Using Excel
.
=INT((TODAY()-DOB)/365.25)
Рекомендации по теме
Комментарии
Автор

How do you calculate person's age on their birthday in 2012?

jcricket
Автор

What if Today is some other day and I need number of days instead years?
Thanks Krishna531

HinaPanchal
Автор

Use this instead
=DATEDIF(A13, TODAY(), "Y") & " Years, " & DATEDIF(A13, TODAY(), "YM") & " Months, " & DATEDIF(A13, TODAY(), "MD") & " Days"

arupvns