How to calculate age in Excel with birth year

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

Initial Solution