Hi Guys,
We want to create a list view for all upcoming appointments tomorrow, but want to exclude weekends. For example, if its Friday, we would want it to populate with Monday's appointments.
I have tried a few formulas but none seem to populate correctly when weekends are involved.
Any suggestions?
3 answers
Hi ,
Sorry, I got the formula wrong
TODAY() +
CASE(WEEKDAY( TODAY() ),
6,3,
7,2,
1) = appointment_date__c
