Google Sheets Formula – show an age from a DOB

I couldn’t find a decent formula to show an age from a Date Of Birth, so I wrote this:

=CONCAT(FLOOR((TODAY() - B2)/365),CONCAT("y ",CONCAT(FLOOR((((TODAY() - B2)/365) - FLOOR(((TODAY() - B2)/365))) * 12), "m")))

Shows an age in years and months; e.g. “10y 6m”.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

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