| 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.
Posts
