How to calculate age in Excel with birth year

Save
2 years ago

Hello, My Dear Friends, !! In this video, I will show you How To Calculate Age in Excel. Watch the video till the end Thanks.

Here,s How To Calculate Age in Excel :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Step 1: Open Excel.
Step 2: Click in the cell where you want the age to appear.
Step 3: Type =TRUNC(YEARFRAC(
Step 4: Select the cell containing the date of birth.
Step 5: Type, TODAY())) and press Enter.
Step 6: The person's age in years is calculated.

Chapters:
0:00 Introduction
0:16 Calculate Age in Excel
2:02 Happy Ending

Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel.

#initial #solution #calculate #age #in #excel #with #birth #year

Loading comments...