Wednesday, January 29, 2020

Excel formula to determine age from date of birth

Birth date Age
15.07.1996 24
07.06.1996 24
05.07.2002 18
04.12.2005 15
19.07.1992 28
23.11.1998 22
28.10.2000 20
02.10.2001 19
23.09.1996 24
09.05.2001 19
27.09.1997 23

Sometimes you might want to get the age of somebody, for instance, în order to determine whether they are minor or major (18 years old).
The German formula is: =(JAHR(JETZT())-JAHR(A2))

An English formula may be: ==INT(YEARFRAC(A2,TODAY()))
or
=IF(INT(YEARFRAC(A1,TODAY()))<18,"Minor","Adult")
or
=DATEDIF(A1, TODAY(), "y")
or with months and days
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"

You may use conditional formatting (bedingte Formatierung) to highlight figures under 18.