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”.
Leave a Reply