This content has been marked as final. Show 2 replies
I need to calculate the number of business days (M-F) between two dates in order to know the age of an order. I'm using
DATEDIFF('day',[Date - Order], TODAY() )
But this is showing me the number of calendar days, including Sat & Sun.
How should i modify my formula to do this? I would name it "Days Old" and i would drop it on the colors card so i could show a bubble or bar vis showing the orders by their age in business days differentiated by color.
Thanks in advance for you help!