In reply to JC.

I wouldn't cite Excel as a perfect solution for shifting a date by a number of workdays including holidays. MS Excel offers WORKDAY function and WORKDAY.INTL function both of which allow for defining custom holidays. However, these holidays must be specified / listed in the function call itself which makes it a hard-coded solution, - not the best programming practice, especially when dealing with a wide range of dates. The goal of this blog post is to demonstrate a universal data-driven approach for solving this problem without having to explicitly supply hard-coded holidays list in the function call.