Display in same excel with different start dates

Help
,
1

Instead of same date(10-10-2017) for every task …hav to use different dates for different tasks.

For example: In the above excel data

For Task two have to start from 9-10-2017 and have to increment upto number of working days.
for task five have to start from 5-10-2017 and have to increment upto taskfive number of working days
for task six have to start from 12-10-2017 and have to increment upto task sixMoinu.xlsx (10.5 KB)
number of working days
Main.xaml (19.6 KB)

Can you pls help me with this!!!

2

Hi Moinu,

We might need more detail on this however this seems like something you could use a switch case for.

Will the task date only be specific cases e.g. Task two will always be one date or is this related to a specific weekday?

Thanks

3

Moinu.xlsx (10.5 KB)
This is the excel file. Based on MicroTaskName and workingdays we have to calculate the date of a week.
For example : If the MicroTaskName is TaskTwo and working days is 6 days. If the date start from 9-10-2017.

for TaskTwo 1st day i have to display date 9-10-2017
for TaskTwo 2nd day i have to display date 10-10-2017
for TaskTwo 3rd day i have to display date 11-10-2017
for TaskTwo 4th day i have to display date 12-10-2017
TaskTwo 5th day i have to display date 13-10-2017 here(14th,15th is saturday and sunday so we have to skip sat&sun)
for TaskTwo 6thday i have to display date 16-10-2017

This is the workflow Main.xaml (19.6 KB)

The problem is In MicroTaskName column in the excel there are different Tasks which start from different dates
for TaskTwo start day starts from 9-10-2017 & working days is 6(so from TaskTwo1 to TaskTwo6 it have to display dates except sat & sun dates)
for TaskFive start day start from 5-10-2017 & working days is 3(so from TaskFive1 to TaskFive3 it have to display dates)
for TaskSix start day starts from 12-10-2017 & working days is 5(so from TaskSix1 to TaskSix5 it have to display)

for better understanding see the excel file (see dates in excel in that way i have to display)