(This is a simplified version of a sheet i am working on)
In Cell D1 to G1 to i have the following text as column headers:
Design started
Design Finished
Development Started
Developement Finished
each project being worked on is contained on a new row. As each stage is started or finshed i enter in the date this occurred under the correct column.
In column C i have a formula that pulls the latest date from columns d to g for that row. What i would like is that the column B for that row will match the stage heading to that date.
E.g. If in Row 4, D4 = 28/10/05 and E4 = 16/11/05, then the latest date in c4 will be 16/11/05. I would like the text "design finished" (as per cell E1) to then be updated in cell b4.
Id really appreciate help with this
Thanks a mill
In Cell D1 to G1 to i have the following text as column headers:
Design started
Design Finished
Development Started
Developement Finished
each project being worked on is contained on a new row. As each stage is started or finshed i enter in the date this occurred under the correct column.
In column C i have a formula that pulls the latest date from columns d to g for that row. What i would like is that the column B for that row will match the stage heading to that date.
E.g. If in Row 4, D4 = 28/10/05 and E4 = 16/11/05, then the latest date in c4 will be 16/11/05. I would like the text "design finished" (as per cell E1) to then be updated in cell b4.
Id really appreciate help with this
Thanks a mill