How to Calculate Age in Excel With Date Of Birth (Easy Formulas)
Learn How to Calculate Age in Excel 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 Excel tutorials 👉 • Excel Tutorials
Subscribe for more tips 👉 https://goo.gl/9JJzbc