Calculate Exact Age in Excel Sheet (DATEDIF Function)

Now lets calculate your exact age with Excel function

Put your date in Excel cell A1


Then place following formula in any cell

=CONCATENATE(DATEDIF($A$1,TODAY(),"y")," Years ",DATEDIF($A$1,TODAY(),"ym"), " Months & ",DATEDIF($A$1,TODAY(),"md"), " Days ")

Now just paste you date in cell A-1

For example today is 03-Dec-2013 & my birth-date is 30-May-1987 (Value in A1)

Then output of this formula will be

26 Years 6 Months & 3 Days

If you found this useful then please share this post with your friends and share it on social sites.