Hi All,
I need to create a calculated column that will result in a "Yes" or "No" as to if a purchase order needs chasing with a supplier or not.
There's some date criteria to factor in, as we want to flag any orders placed in the last 2 working days as "No" (To give a supplier chance to place the order and confirm)
As an example, today (Friday 3rd Feb 23) if I ran the report, I would want to flag any orders placed on the 1st (Weds) or 2nd (Thurs) Feb as "No" don't chase.
If on Monday the 6th Feb 23 I run the report, I would want to flag any orders placed on the 2nd (Thurs) or 3rd (Fri) Feb as "No", as these are the last 2 working days.
As a starting point I have =IF(NOW()-Date<=2,"No","Yes") But this doesn't factor in the working days so when "Date" is a Monday, it's looking at Saturday and Sunday, not Thursday and Friday. I'm not sure how to find the working days. WEEKDAY looks like a potential option, but I have no idea how to factor it into my formula.
Any help would be appreciated. Thanks
