Hello,
Has anyone come up with a formula or way to exclude weekend days from a transaction search?
Example:
Customer places an order on Friday 5/14 and it ships out on Monday 5/17. I only want to calculate business days for the amount of time for it to ship out. In this example I want the result to be 1 instead of 3 which you get by subtracting the two date fields.
Transaction date - Fulfillment Date = Business Days Only
Any help would be appreciated.