Excel Formula: Lookup Next Date of a Value after Today

This video will use an Excel formula to look up the date of the first occurrence of a value after today's date. In the example, we have a list of courses running each day. We want to easily find the next course to run after today. This is accomplished by using the wonderful INDEX and MATCH functions together in an array formula. In the video, we walk through the scenario and the solution. We then explain how it works in detail. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us!