
My requirement is that I want to calculate the number of days between the minimum date from the MinActStart list and max date MaxActEnd list . I should get two columns having minimum dates from MinActStart i.e. 6/24/2019 in this case and 7/8/2021 as MaxActEnd so the new columns should show me dates like min as 6/24/2019 for all tasks ids and max as 7/8/2021 ,, and this should change when I change the tasks