Hellow guys, Welcome to my website, and you are watching How To Convert Date of Birth Into Age Quickly In Excel. and this vIdeo is uploaded by Excel 10 tutorial at 2019-01-02T11:19:03-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | How To Convert Date of Birth Into Age Quickly In Excel |
| Video Uploader | Video From Excel 10 tutorial |
| Upload Date | This Video Uploaded At 02-01-2019 14:19:03 |
| Video Discription | How to change or convert birth date into age in excel 2010. Greetings and welcome to Excel 10 Tutorial. In this quick tutorial I will demonstrate how you can change a birth date into Age. You can use this tutorial to solve various problems. So don’t forget to comment how you used it. Now. We will be using DATEIF function to convert date into age. No VBA is used in this tutorial. This is a basic excel tutorial yet worth knowing. Follow the instructions below to change birthday into age in excel 2010. Step 1: Open Microsoft Excel 2010. Step 2: Write the Date of Birth in Cell A2 (Cell A2 used for demonstration purpose only). Step 3: Write =DATEDIF(A2,NOW(),"y") to any cell where you want the age. #excel10tutorial #DateOfBirth Now if you need to find out exact age of a person with Year, Month and day you can do it by changing the function with this: =DATEDIF(A2,TODAY(),"Y") & " Years, " & DATEDIF(A2,TODAY(),"YM") & " Months, " & DATEDIF(A2,TODAY(),"MD") & " Days" Everything else remains same. This is how you calculate age in excel in years, months and days. If you have any questions please leave a comment. ----------------------------------------------------------------------------------------------------------- Support Us: https://www.patreon.com/excel10tutorial ----------------------------------------------------------------------------------------------------------- Thanks for watching. If you like this tutorial, please subscribe: https://goo.gl/uL8fqQ Here goes the most recent video of the channel: http://bit.ly/2oXmqsb Playlists: Advance Excel Tutorial: https://goo.gl/ExYy7v Excel Tutorial for Beginners: https://goo.gl/UDrDcA Excel Case: https://goo.gl/xiP3tv Excel VBA Programming Course: http://bit.ly/excelvbacourse Social media: Facebook: https://facebook.com/excel10tutorial Twitter: https://twitter.com/excel10tutorial Blogger: https://excel10tutorial.blogspot.com Tumblr: https://excel10tutorial.tumblr.com Instagram: https://www.instagram.com/excel_10_tutorial Hubpages: https://hubpages.com/@excel10tutorial |
| Category | Education |
| Tags | How To Convert Birthdate To Age Quickly In Exce 2010 | convert date into age in excel 2010 | Age calculator in excel 2010 | calculate age from specific date in excel 2010 | e10t | Excel 10 Tutorial | Excel 2010 | Calculate age in excel | formula to calculate age from date of birth in excel | calculate age from date of birth in excel | Age calculator | Microsoft excel | microsoft excel formulas |
