Azitech

Azimout's Linux weblog

Google Spreadsheet formula for calculating someone’s age

leave a comment »

=datedif(B2, today(), "Y") & " yrs, " & datedif(B2, today(), "YM") & " mnths, " & datedif(B2, today(), "MD") & " days"

(B2 is the birthdate)

Written by azimout

09/09/2014 at 09:38

Posted in Uncategorized

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.