Hi Kingsly,
I just wanted to ask for some clarification on the formula for field 3.
- If the "template type" is selected as "A" or "B", I want the "planned duration" to add "30 days" (including weekends) to the "start date" and give me an output in "# of days"
So if the template is A or B you want to take the Start Date and add the "planned duration to it" to get you a # of days. a # of days from Today? a # of days from another date field? Should it be counting down each day to that new date 30 days after the start date? Or should the planned duration field just read 30 days when A or B is chosen and just read 60 days when the option c is chosen and not change?
