M
Manosh
Hi all
I am trying to create a simple gant chart for which i would like to
enter the start date and the end date of a period of work.
I am using numbers in the rows to show the days of involvement and in
two columns i am showing the start and end dates which is shown as the
numbers 1-4 below:
1 2 3 4 Start End
Task 1 3 3 1 2
Task 2 1 1 1 2 4
Task 3 1 4 4
Could someone help me come up with a find first and last formula for
the respective cells?
Many thanks
Manosh
I am trying to create a simple gant chart for which i would like to
enter the start date and the end date of a period of work.
I am using numbers in the rows to show the days of involvement and in
two columns i am showing the start and end dates which is shown as the
numbers 1-4 below:
1 2 3 4 Start End
Task 1 3 3 1 2
Task 2 1 1 1 2 4
Task 3 1 4 4
Could someone help me come up with a find first and last formula for
the respective cells?
Many thanks
Manosh