I need to edit the date diff formula to be in workdays and exclude weekends. Does anyone know how to accomplish this in Sage Alerts? I found this formula example online, but does it have to be this complex? Having trouble replicating it. This is Sage 100 Advanced version and Sage Alerts v10.
DateValue(Format([Due Date],"mm/dd/yyyy"))-[Order Date]+1-(DateDiff("ww",[Order Date],DateValue(Format([Due Date],"mm/dd/yyyy")),7)-(Weekday([Order Date])=7))-(DateDiff("ww",[Order Date],DateValue(Format([Due Date],"mm/dd/yyyy")),1)-(Weekday([Order Date])=1))
