I am trying to calculate the difference between two dates using Datediff but only count working day. The workday Y/N is in the Date Table, the other two dates is between today and order date.
When I use Datediff(todayutc,orderdate, days), the formula works fine. However I only want to count workdays. Can I do this with the Datediff function? Negative days is also counting hence I cannot use betweendates function.