Last Updated:
How To Calculate Age in MS Excel (Tutorial)

How To Calculate Age in MS Excel (Tutorial)

Hi Friends, its my first Post about Microsoft Excel. MS EXCEL is accounting based program and every body know about it.

excel tutorial date calculation

Formula for Calculating Age in Excel

Today my first post about EXCEL and it is about how we can calculate age in Microsoft Excel this feature was not setup in old version of excel in i.e. Excel 5 , 7 or Excel 97 but its work in Excel 2000, Excel 2003 and Latest versions follow This..
For on only Year: =DATEDIF(A1,TODAY(),"y") Then Month: =DATEDIF(A1,TODAY(),"ym") And Days: =DATEDIF(A1,TODAY(),"md")
Image for ready reference

If you want to calculate your age in text version try this.
For Complete ="Your Age is "&DATEDIF(B1,TODAY(),"y")&" Years, "&DATEDIF(B1,TODAY(),"ym")&" Months & "&DATEDIF(B1,TODAY(),"md")&" Days"
see this

You can change text “Your Age is” into your own text like if there is any product and you have set any expiry date and you can change it in whatever you want

Comments