Let ( [ D = YourDateFieldorVariableHere ;
Sun = D - DayOfWeek ( D ) + 1 ;
Mon = Sun + 1 ;
Wed = Sun + 3 ;
Sat = Sun + 6 ] ;
Case ( Mon >= D ; Mon ;
Wed >= D ; Wed ;
let ( weekday = DayOfWeek ( date );
case(weekday=0; // sunday
1; // add 1
2; // add 2
As Coherenkris points out FileMaker has exactly what you need. All you need to do is convert a 1 to Sunday, 2 to Monday. The results are numeric.
Review the answers based on what you stated your answer is here.
I think you may wish to finish this out for the OP.
Day is Sunday, +1 // the following Monday
Day is Monday, + 2 // the following Wednesday
Day is Tuesday, + 1 // the following Wednesday
Day is Wednesday, + 3 // the following Saturday
Day is Thursday, + 2 // the following Saturday
Day is Friday, +1 // the following Saturday
Day is Saturday, + 2 // the following Monday
What you want to is advance the day if it is a certain day of the week (what about holidays)?
Advance date: date + Number of days
Nbr = dayof week(advancedate)
If nbr = 1 //sunday
nbr = 2 //monday
Advancedate = date + nbr
Check the actual numbers produced by dayofweek() and adjust accordingly.
You can adjust this idea to work with actual dates (July 4th, etc)