If the record is created on a Sunday, such as 11/08/2015 (MMDDYYYY), do you want the date for the very next day or a week later?
11/09/2015 or 11/16/2015?
The basic calculation would be:
Let ( [ D = yourDatefieldHere ;
S = D - DayOfWeek ( D ) + 1 // preceding Sunday
S + 8
But if you want 11/09/2015, we'd need to include an If or Case function to add 1 instead of 8 when D falls on a Sunday.
The records would only be created on a weekday. So Saturdays and Sundays would not come into play.
Also, if this falls on a Monday, would it show that Monday's date or the following?
As written, it would show the following Monday. If you need that date to remain the same, we'd need that IF or Case function to keep that change from taking place.
Works perfect! Thanks! Saves the days again appreciate it!