Niyas C | How to Calculate Age From Date of Birth in Excel @niyasc | Uploaded 1 year ago | Updated 14 hours ago
How To Calculate Age In Excel From A Date Of Birth? | Excel Tutorials For Beginners | Age calculating formula in Excel from Today
This video tutorial offers a step-by-step guide on how to calculate age using a date of birth in Excel. Youll be able to find out the exact number of years that passed from date of birth until now.
How to Calculate Current Age in Full Years
Open Excel.
Click in the cell where you want the age to appear.
Type =TRUNC(YEARFRAC(Select the cell containing the date of birth,TODAY()))
Press Enter and The persons age in years is calculated.
How To Calculate Age In Excel From A Date Of Birth? | Excel Tutorials For Beginners | Age calculating formula in Excel from Today
This video tutorial offers a step-by-step guide on how to calculate age using a date of birth in Excel. Youll be able to find out the exact number of years that passed from date of birth until now.
How to Calculate Current Age in Full Years
Open Excel.
Click in the cell where you want the age to appear.
Type =TRUNC(YEARFRAC(Select the cell containing the date of birth,TODAY()))
Press Enter and The persons age in years is calculated.