1 Reply Latest reply on Oct 18, 2019 1:53 AM by lei.chen.0

    DateDiff - Exclude Weekends & Certain Dates

    Joe Smart

      Hi All,

       

      Hoping someone can help me out here - I need to do a date diff between the 'Start Date' and 'End Date' to create a duration.

       

      But I need to exclude the following from the duration calculation :

       

      • Weekends
      • 01/01/2019
      • 19/04/2019
      • 22/04/2019
      • 30/05/2019
      • 10/06/2019
      • 01/08/2019
      • 05/09/2019
      • 25/12/2019
      • 31/12/2019

       

      Attached is a packaged workbook. There are around 800 rows.

       

      Thanks for all your help in advance