Forum Discussion
Iterating and comparing rows
I have a table of tasks assigned to different people, with set due dates, hours and priorities. I have previously processed these (in Visual Studio) to determine an order of works. This was done by ...
In step 2, how would one know whether a project is on-time or not? Also in row 2, 15/8 + 10 workdays shouldn't that be 29/8?
If ProjectedEndDate is on or before DueDate than the project is ontime
Take "TODAY" as 1 August. For example in Step 2 (screenshot below)
- Row one is 5 days and so ProjectedEndDate is 8 August
- Row two is 10 days and so ProjectedEndDate is 10 working days AFTER the end date of Row 1 (so 8 August + 10wd = 22 August)