How to Find Age in Excel Formula - Tips and Tricks by @technicalinfluencer

How to Find Age in Excel Formula - Excel Tips & Tricks

Highlights:
What is the formula to calculate age?
How do I calculate age from a specific date in Excel?
How do I calculate age in Excel with formula?
What is the shortcut to calculate age?
How do you calculate age in auto fill excel?

Image result for how to find age in excel formula
The simplest and most accurate formula to calculate age in Excel is =DATEDIF(birth_date,as_of_date,"y").

As you have just seen, calculating age as the number of full years that the person has lived is easy, but it is not always sufficient. If you want to know the exact age, i.e. how many years, months and days there are between someone's birth date and the current date, write 3 different DATEDIF functions:

To get the number of years: =DATEDIF(B2, TODAY(), "Y")
To get the number of months: =DATEDIF(B2, TODAY(), "YM")
To get the number of days: =DATEDIF(B2,TODAY(),"MD")

Where B2 is the date of birth.

And then, concatenate the above functions in a single formula, like this:

=DATEDIF(B2,TODAY(),"Y") & DATEDIF(B2,TODAY(),"YM") & DATEDIF(B2,TODAY(),"MD")
.
Have you tried this one before?
.
Don't forget to save this post for future reference!
.
For more videos subscribe our channel and press bell icon.. @technicalinfluencer
.
#excel #exceltips #exceltricks #exceltutorial #tutorial #tutorials #shorts #shortsvideo #youtubeshorts #trending #viral #newtrick #finance #corporate #accounts #spreadsheet #workbook #workhacks #workfromhome #new #videoshort #videooftheday #trickoftheday #msexcel #microsoft #microsoftexcel #computer #education #tricks #tips #short #shortsyoutube #excelformulas #excelformulasandfunctions #excelformula #excelfunction #excelfunctions #500subs #500subscribers #500subscriber #subscribemychannel #subscribeme #technicalinfluencer #ti @YouTube @youtubecreators

basic excel, excel, advance excel tips and tricks, excel tricks, excel tips, excel tutorial, microsoft excel, excel world, excel tutoring, excel formula for job interview, Excel world, advance excel tips & tricks, excel tutoring formula, shorts youtube, short, Excel interview questions, excel formulas and functions, excel formula hacks, excel short video, excel shorts, advanced excel tips, excel shortcuts, basic excel tutorial, excel formula, excel shortcut keys, learn excel, learn basic excel