Excel Formulas Part 6: Date Difference including Working Days Only

In this video we calculate date difference using an Excel formula. We then extend the formula to calculate only the workday days difference between 2 dates. A couple of useful date functions are learnt in this video. This builds up your Excel function list and also provides practice of typical Excel formula tasks. Enroll in the complete Excel Formulas course and become an expert in formulas in just a few hours. Over 100 formula examples - https://www.udemy.com/excel-formulas-made-easy/?couponCode=FormulasYouTube In this video the date difference is calculated to produce the number of days until a due date or deadline. This is extremely useful. This formula could be switched to produce the number of days since a date instead. This video is the sixth in our series to learn Excel formulas. It is aimed at beginners to Excel formulas to get to an intermediate level quickly and easily. Previous video - Reference sheets and other workbooks in Excel formulas - https://youtu.be/GJxY2yu9l9c Next video - Absolute cell reference v relative cell reference in Excel formulas - https://youtu.be/b2wcFAb0v8k Download the FREE eBook of '27 Excel Hacks to make you a Superstar' - http://www.computergaga.com/27-excel-hacks-to-make-you-a-superstar.html Find more great free tutorials at; http://www.computergaga.com Connect with us!