I need to calculate a date based on the value of 2 columns on a SharePoint Task list:
- A Date and Time column that contains a date, called Due Date. The Due Date might be a different date for each task (item) in the list.
- A Number column that contains an integer, called Business Days. The number in the Business Days column might be a different number for each task (item) in the list.
The month of the new calculated date needs to be equal to the next month of the date in the Due Date value. The day is calculated taking into account the number of business days indicated by the Business Days column.
For example, the value in the Due Date is April 7th, 2016, and the value in the Business Day column is 5. The new date should be equal to May, 6th 2016; because the next month to April is May, and the 5th business day of May is the 6th.
Can this be accomplished in Nintex WF 2013? Thanks in advance for any help you may offer.