In this video, I will show you how to calculate age in Excel in Years, Months, and Days (when you have the date of Birth).
This can easily be done using the DATEDIF function, which is a legacy function and is made available for compatibility reasons with LOTUS 123.
With Datedif you can calculate:
— Total years that have passed in between the date of birth and current date
— Total number of months that have passed in between the date of birth and current date
— Total number of days that have passed in between the date of birth and current date
You can also read more about this here: https://ift.tt/32Ryp9y
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial