Schedule Dates Minus 2 days Except Weekends

I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the automated email will go out the Friday before instead of the Saturday before.

Best Answer

Answers