Hello all, first post and kinda new to Excel.

I am using 2010 Excel, and I am trying to get timelines in between dates.

Here is what I would it work out like.
Enter my Start date, from that date it counts forward (not including weekends) until the next date is entered and stopped.

How can I create this, as I am trying to have a metrics on duration for each phase.



Start Date Phase 1 Days Between Start/Finnish Phase 1 Finish Date Phase 1 Days Between Finish Phase 1 and Start Phase 2 Start Date Phase 2 Days Between Finsh Date Phase 2
3/6/2012 7 3/15/2012 9 3/28/2012 counts days and then stops after Finish Date Phase 2 is entered ?

If you should need any more info let me know.