Hellow guys, Welcome to my website, and you are watching Excel - Secret Formula to Calculate Age DateDif - Episode 2472. and this vIdeo is uploaded by MrExcel.com at 2022-03-05T02:55:21-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel - Secret Formula to Calculate Age DateDif - Episode 2472 |
| Video Uploader | Video From MrExcel.com |
| Upload Date | This Video Uploaded At 05-03-2022 05:55:21 |
| Video Discription | Microsoft Excel Tutorial: Calculating age from two dates. Welcome to the MrExcel Podcast episode 2472, where we will be discussing a secret formula in Excel that will help you calculate someone's age. In today's episode, we will be answering a question from Doug in Boston, who wants to know how to calculate the age of someone born in 1955. Well, Doug, you've come to the right place because I have not one, but two easy ways to do just that. First, we can use the =YEARFRAC function. Simply input today's date using the =TODAY() function and then use the =YEARFRAC function to calculate the difference between the two dates in years. In this case, the person would be 67 years old. Another option is to use the =DATEDIF function. Input the earlier date, which would be the person's birthdate, and the later date, which would be today's date. Then, in quotes, specify that you want the result in years. This will also give you the person's age, which in this case would be 67. It's always great to have multiple ways to solve a problem in Excel, but these two formulas will ensure that you get the correct age every time. If you enjoy these videos, please don't forget to Like, Subscribe, and Ring the bell down below. And as always, feel free to leave any questions or comments in the comment section below. I want to thank Doug for sending in his question and I want to thank all of you for tuning in. Stay tuned for more helpful tips and tricks in Excel on the MrExcel netcast. This is Bill Jelen, signing off. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents (0:00) Problem Statement: Calculate Age in Excel (0:20) TODAY() function in Excel for current date (0:30) YEARFRAC() function in Excel (0:40) DATEDIF() function in Excel (0:58) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1198232/ Doug from Boston needs to calculate an age in Excel. Two easy formulas today: YEARFRAC and DATEDIF. This video answers these common search terms: how to use yearfrac in excel how to do a datedif function excel how to use excel formula datedif how to use datedif function in excel Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ |
| Category | Education |
| Tags | Microsoft Excel | Excel | Bill Jelen | MrExcel | Calculate years in Excel | Calculate age in Excel | How to use the YEARFRAC function in Excel | How to use the DATEDIF function in Excel |
