Previous Lecture Complete and continue  

  Date Math: Calculating Project Completion Dates - Dependent Tasks

Learn how to combine the workday function along with the iferror and max functions and an index/match lookup to create a scheduling tool to estimate when a list of tasks will be completed based on the duration of each task. Here you'll build a tool that takes weekends and scheduled holidays into consideration, as well as, task dependencies.