If I have an action that is comprised of mutiple tasks which all have a complete date, and the action is only complete when the final task is complete.
How would I capture that date in a cell for Action Complete.?
There is another variable in that there are a number of different types of action, 6 in all. Each type of action is comprised of different tasks. I am thinking there fore that each action type would need its own unique formula to calculate the Action Complete date specific to that type of action.
Hopefully I have explained the above clearly enough.
How would I capture that date in a cell for Action Complete.?
There is another variable in that there are a number of different types of action, 6 in all. Each type of action is comprised of different tasks. I am thinking there fore that each action type would need its own unique formula to calculate the Action Complete date specific to that type of action.
Hopefully I have explained the above clearly enough.