How to Calculate Age in Google Sheets Using Date of Birth (Easy Formulas)
Learn How to Calculate Age in Google Sheets in a few steps.
Read the Blog 👉 https://softwareaccountant.com/calcul...
Formula to get age in years:
=DATEDIF(A2, TODAY(), "Y")
Formula to get Age in Months:
=DATEDIF(A2, TODAY(), "M")
Formula to get Age in both Months and Years:
=DATEDIF(A2, TODAY(), "Y") & " years, " & DATEDIF(A2, TODAY(), "YM") & " months"
Other Google Sheets tutorials 👉 • Google Sheets Tutorials, Tips, and Tricks
Subscribe for more tips 👉 https://goo.gl/9JJzbc