I have an existing validation Rule:
AND( OR(Allocated_Date__c <= TODAY(), Allocated_Date__c = TODAY()+1 ), RecordType.DeveloperName = 'Control_Visit', ISPICKVAL(Status , 'Complete') )
This works currently and ensures records aren't saved if the allocated date is in the past or today +1. However I would like to adjust it so the +1 only accounts for business days and not weekends. For example, the validation if ran today allows for allocated days of Monday when it should only accept dates from tuesday onwards. Naturally the other pieces of validation apply too.
i've been reading about using Case, Mod and comparing date values like this:
Unfortunately I couldn't figure it out :(