Categories
Code

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”.