Friday, April 10, 2015

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 - " & DATEDIF(B2,DATE(2015,8,12),"YM") & " Months"