Still haven't had any luck..
I tried "=StartDate+(Duration*7)"
I dont think that is going to work.. Any other suggestions on how to flood in the month data based on weeks?
If I use:
January 2009 = Start Date
Phase 1 = 4 Wks and 1 man
Phase 2 = 2 Wks and 2 men
Phase 3 = 3 Wks and .5 men
I need it to automatically calculate..
January - We need 1 men
February - We need 2 men for the first two weeks then .5 men for the last two weeks.
March - .5 men for the first week
If I use the simple math way - It doesn't work right..
Like If I put my Start Date as January 2009 And input my phases:
PHASE WEEKS
Proposal 6
Estimate 6
FEED 24
DD 6
Proc 6
CloseOut 2
Then if I do the Start Date + the Week amount per phase multiplied by 7 I get:
February-09
February-09
June-09
February-09
February-09
January-09
And if I adjust the formula to pull the Start Date from the previous start date just calculated:
February-09
March-09
September-09
October-09
December-09
December-09
It starts to work.. but it doesn't still..
Any ideas?
Thanks!
Bookmarks