We have a SharePoint site that we use to schedule customer appointments. These appointments need to be scheduled on a weekday and need to be at least three business days away, but no more than 45 days away. For example, if they are making a new appointment on a Friday, we can't have it scheduled on the following Monday or Tuesday because it will not give us enough time to prepare the product. Also, we need to prevent them from scheduling the appointment on Saturdays and Sunday. We currently use a 3 days out formula, but need to have a formula that will not count the weekend in the 3 days formula. Please help.
Here is the current "Column Validation" formula we are using: =IF([Requested Day Off]TODAY()+2,TRUE,FALSE)
I have also tried list validation without success. I am open to either.