I'm having a complete brain fart trying to figure this out. Let's say I have 600 man-days left of work to complete, and this is located in cell E3. I want to calculate the target date for completion based on a given team size. Currently I'm doing this with
but this only works for a fixed team-size of 6.5. However, I know that for the next 30 days of this project, I'm going to have a team size of 10.
Is there a formula I can use that will give me the target date while factoring in the staffing change?