Sign in to confirm youā€™re not a bot
This helps protect our community. Learn more

Calculate AGE in Excel from Date of Birth (in Years, Months, & Days)

TrumpExcel
420K subscribers
<__slot-el>
<__slot-el>
149K views 5 years ago #ExcelTips #ExcelTutorial #Excel
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://trumpexcel.com/calculate-age-... Free Excel Course - https://trumpexcel.com/learn-excel/ Paid Online Training - https://trumpexcel.com/excel-training/ Best Excel Books: https://trumpexcel.com/best-excel-books/ āš™ļø Gear I Recommend: Camera - https://amzn.to/3bmHko7 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - https://amzn.to/2uzhVHd Wireless Mic: https://amzn.to/3blQ8uk Lighting - https://amzn.to/2uxOxRv Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial ...more
...more
Calculate AGE in Excel from Date of Birth (in Years, Months, & Days)
1.2KLikes
149,482Views
2019Oct 27
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://trumpexcel.com/calculate-age-... Free Excel Course - https://trumpexcel.com/learn-excel/ Paid Online Training - https://trumpexcel.com/excel-training/ Best Excel Books: https://trumpexcel.com/best-excel-books/ āš™ļø Gear I Recommend: Camera - https://amzn.to/3bmHko7 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - https://amzn.to/2uzhVHd Wireless Mic: https://amzn.to/3blQ8uk Lighting - https://amzn.to/2uxOxRv Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial

Follow along using the transcript.

TrumpExcel

420K subscribers
26
FREE Excel Course (Basic to Advanced)
by TrumpExcel