Microsoft Excel Tip: How to represent a date as years, month and days in microsoft excel - (Age Calculator)

You can easily calculate your age on a specific date using DatedIF function in MS Excel.

                                If your Date of Birth is stored in a cell as below :

You can use below Syntax to Calculate your current age in measures of  

Year, Months and Days :

Please do like and follow our Facebook page here
For help with any query related to MS Excel feel free to e-mail us here

If you want to learn more such tricks, you may consider buying these products from Amazon

101 Best Excel Tips & Tricks

Microsoft Excel 2016 Tips & Tricks

• Please do like and follow our facebook page here
• For more queries, feel free to e-mail us here
• Just to let you know, we are an Amazon Associate. To help and support us, you can shop for different products available on Amazon from here