How to Convert Days & Dates into Years Months & Days #MS Excel #exceltutorial

How to Convert Days & Dates into Years Months & Days Convert Date & Days into year month & days. MS Excel Days convert formula: =DATEDIF(0,D5,"Y")&" Years "&DATEDIF(0,D5,"YM")&" Months "&DATEDIF(0,D5,"MD")&" Days " Date convert formula: =DATEDIF(C10,D10,"Y")&" Years "&DATEDIF(C10,D10,"YM")&" Months "&DATEDIF(C10,D10,"MD")&" Days " Calculate Age in Excel | Get the AGE in Years from Date Of Birth in Excel | Age Calculator Calculate AGE in Excel from Date of Birth (in Years, Months, & Days) You Tube Link :- Excel Free Online Training Course - 1 :- https://youtu.be/_nws61rQdT8 Learn Excel Home Menu and File Menu -2 :- https://youtu.be/5xHnxNoRrig Learn Excel Account File and Excel Options -3 :- https://youtu.be/fqVyuz0mxAk Learn Excel Merge and Center | Wrap Text -4 :- https://youtu.be/u-iNR0fn8Q8 Learn Excel Autofill and Costom List -5 :- https://youtu.be/-0NZwr7He4E Learn Excel Maintain Stock Inward and Outward-6 :- https://youtu.be/dZv_Dg-kuQY How To Create Profit & Loss Report In Excel -7 :- https://youtu.be/8Dey6u-LoHU How To Calculate Loan |Interest in Excel -8 :- https://youtu.be/BOtUAK4Ra-A How To Create Salary Sheet in Excel | Advanc e -9 :- https://youtu.be/pRTvtvyXgr4 How To Use Tax in Excel – 10 :- https://youtu.be/th0Wlhh4Oh0 Excel Formula and Functions Tutorial in Hindi -11 :- https://youtu.be/2aFdryA1lHQ How To Create a Hyperlink in Excel – 12 :- https://youtu.be/IT5a2s0dt4Y Consolidate Multiple Sheet into One Sheet in Excel - 13 :- https://youtu.be/cp2rJKHcWVM How To Create Complete Marksheet in MS Excel Step by Step -14 :- https://youtu.be/FxC5xYDykxI How To Pictures in Excel & Filter + Shorting + Image Adjust in Excel-15 :- https://youtu.be/-UT-c6ecTPY Excel Tips To Flash Fill For Excel – 16 :- https://youtu.be/wrpT4rk5v9k Certificate Create in Ms Excel – 17 :- https://youtu.be/CzsxxRZgv3I Compare Two Columns in Excel – 18 :- https://youtu.be/JFUNriyCTVE Using Spin Button and Scroll Bar in Excel – 19 :- https://youtu.be/BGgPGztzv0Q STUDENT ENQUIRY FORM IN EXCEL – 20 :- https://youtu.be/zU4haMhAjxs How To Make Sales Report In Excel – 21 :- https://youtu.be/zn03VEpaDZs How To Use The XLOOKUP Function in Excel – 22 :- https://youtu.be/3KeAWU_oNp4 How to Create Doughnut Chart in Excel – 23 :- https://youtu.be/vA0jjKjzRZE Advanced Pivot Table Relationship – 24 :- https://youtu.be/3GRvghryNLs Student Fee Management User Form With VBA in Excel – 25 :- https://youtu.be/z-ER8BrkdNY How To Make Bill Book Entry in Excel – 26 :- https://youtu.be/0cctnwVvvqA How to make Automated Calendar in Excel – 27 :- https://youtu.be/g376IAvTrY4 Automatic I-d Card Using Excel Data – 28 :- https://youtu.be/H5bVIB0JZqk How to Create Mark Sheet in MS Excel – 29 :- https://youtu.be/Q6rq3dhfjhA Student Report Card In Excel – 30 :- https://youtu.be/OXf-8qROZQ0 Consolidate Worksheets in Excel with Data Consolidation Tool – 31 :- https://youtu.be/ctlVgXnstUQ Useful Excel Formula and Function – 32 :- https://youtu.be/-lx5OremJho VBA Userform And Coding In MS Excel – 33 :- https://youtu.be/YLJ5hr7MXcE How To Calculate Personal Expences in Excel – 34 :- https://youtu.be/KbOGRpJvrso Conditional Formating Complete Video in Excel – 35 :- https://youtu.be/QSm_ePoybA4 How to Calculate Age Using Date of Birth in Excel – 36 :- https://youtu.be/cogQhrcLHvk Consolidate in Excel | How to use Consolidate in Excel – 37 :- https://youtu.be/Yjku5ks82xs How to Create Userform in Excel in Hindi | Student Management System in Excel – 38 :- https://youtu.be/3iXT7r1CjIc Advance Excel Assignment-1 | Countif | Counta | Sumif | Total | Average | Grade. – 39 :- https://youtu.be/h0ZkAZoLpwQ Advance Excel Assignment – 40 :- https://youtu.be/WFLMVE8SJHU Excel Learning Mantra Tutorial in Hindi – 41 :- https://youtu.be/Eo1wQCEtJ58 Join Us :- Instagram https://www.instagram.com/nk_excel_classes/ Blog :- https://sites.google.com/ Telegram: - https://t.me/nkexcelclasses Facebook: - NK_Excel_Classes About This Channel 1- We provide best educational videos. 2- Advance Excel 3- Computer Fundamental. 4- Technology. 5- Ms-Office 6- Tally 7- Busy. 8- Html 9- Graphic Design 10- others