7 Replies Latest reply on Feb 16, 2016 7:53 AM by Michael Woodward

    exclude holidays when counting days using datediff

    Alexis Jasinski

      I am using the following calculation to exclude weekends:

       

      ([Date End]-[Date Start])-

      if

      (DATEDIFF('year',[ Date Start], [Date End]))>=1

      then

      (2*((DATEPART('week', [Date End]) + 52*DATEDIFF('year',[ Date Start], [Date End])) - DATEPART('week', [Date Start])))

      else

      (2*(DATEPART('week', [Date End]) -DATEPART('week', [Date Start])))

      End

       

      I also need to exclude holidays. Does anyone know of a way to do this?