|Still not sure of what you want.|
Cell A1 is Date Submitted
Cell B1 is Date Required
estimated date for completion should always plus 13.5 weeks
Does this mean 13.5 weeks from Date Submitted?
Doesn't that make Date Required = 13.5 from Date Submitted?
What about Date Required?
if the date required is more than 1 week and the % complete is 90%
What happened to 13.5 figure?
How do you know it's 90% completed?