How to calculate age from date of birth in Excel or LibreOffice Calc
To calculate the age from date of birth in excel, use this formula in column B (assuming I have the Date Of Birth data in column A): =DATEDIF(A2,TODAY(),"Y") & " Years, " & DATEDIF(A2,TODAY(),"YM") & " Months, " & DATEDIF(A2,TODAY(),"MD") & " Days" | A | B | 1 | DOB | Age | |---------------|---------------| 2 |04/28/1989 | | |---------------|---------------| 3 |12/08/1988 | | |---------------|---------------| If you want to calculate age at a certain date, for example 08/12/2015, use this: =DATEDIF(B2,DATE(2015,8,12),"Y") & " Years - " & DATE...