Hi I'm working on this timeline that is suppose to show the start and the end date for a certain number of tasks.Please see pics for a better idea. The dates are shown week by week (mondays) and they will change respecting to the program that they are related. So what I want to have is a timeline that will autopopulate the dates respecting to that first date. What i did was to relate the first cell in each row (year, month, day) with the start date that is on a separate sheet. Then I sum 7 days all the way to the right and for a row im displaying the years, for the other one the months and for the other one the days.
The problem is that to make it look better I want to merge all the cells that contain the same month or the same year. when i do this by using the merge and center button the sequence gets messed up because it is only using the value in the first merged cell and deleting the others.
Is there a way in which i can do al this automatically and not having the sequence problem? Or any suggestion of a simpler way of doing this?
thanks for the help
The problem is that to make it look better I want to merge all the cells that contain the same month or the same year. when i do this by using the merge and center button the sequence gets messed up because it is only using the value in the first merged cell and deleting the others.
Is there a way in which i can do al this automatically and not having the sequence problem? Or any suggestion of a simpler way of doing this?
thanks for the help