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"