I have a form that has a date1 field. When this date field is filled in I have another date2 field that I want to populate based on the 1st date field + a field named txtSchedFreqDays.
But there is another field on the form named txtSchedFreqMonths. In the event this field has a values entered the the formula would be 1st date field + a field named txtSchedFreqMonths.
Either txtSchedFreqDays OR txtSchedFreqMonths will have a number value. Never both.
But here's the catch... in both cases I never want the date2 field to be populated with a weekend date. Always move to the following Monday.
Can this be done?