Please any help
A1 = Task Starating date B2 = Task ending date C1= Task Duration
A2 = Sub Task 1 Starting Date B2 = Sub Task 1 Starting Date C2= Sub Task 1 Duration 5 Days
A3= Sub Task 2 Starting Date B3= Sub Task 2 Starting Date C3= Sub Task 2 Duration 6 Days
A4= Sub Task2 Starting Date B4 = Sub Task 3 Starting Date C4= Sub Task 3 Duration 7 Days
Formulas on A1 =MIN (A2:A4) Give a Date ( This Correct )
Formulas on B2 = A1+C1 -1 Give a Date ( This Correct )
Formulas on C1 =MAX(C2:C4)-A1+1
Here I have a Problem I want to average in day the length / duration of the task on C1 , but instead I am getting some strange number
Any Hint
Bookmarks