4 Replies Latest reply on Mar 30, 2016 6:56 AM by Michael Hesser

    Is there a way to exclude weekends and defined holidays from datediff calculations?

    John Sobczak

      Is there a way to exclude weekends and defined holidays from datediff calculations?  For example using datediff ('day', January 15, 2012, February 15, 2012)  yields 31, but that includes 4 saturdays and 5 sundays that were in the period.  How can I exclude those in the calculation to yield 22?