Rylo,

Here are the answers to your questions.

1) I need the code to use the actual date for a phase assuming it exists, otherwise I need it to be based off of what the projected date is.
2) I actually need the control phase to go for a 3 month period on the chart that it creates and that should be where the date header ends. For example, if the project with the last control date is on 9/1/2010, the date headers would go to 11/1/2010 and a C would be where the analysis is for the final 3 months.
3) I misspoke about something not getting to control. If there is nothing in the actual date for any of the phases, I would like it to default to the projected date. There should be no instances where there is no projected date, so that should not be an issue.

I also noticed in the analysis that if say for instance the define phase started on 8/1/2009 and then the measure phase started on 8/15/2009, that there is a D and M in the analysis for that month. That is perfect. The issue that I am having is that for the months after that, there will continue to be DM in every month, even though there should only be an M because the define phase has ended when the measure phase started. Do you see any way to fix that?

I apologize for so many questions, but this is very close to being perfect and if it is possible to get these last few things changed, it will be. Thank you.