I have an excel sheet with a start and end date column(cell b2/c2),
10/1/14 and 20/1/14
i would like colums c to az have the weeknumbers as headings
if within the range from columns d to az the start and finish dates are >= start date and <=
end date then can we highlight the respective rows so it gives us a gantt type view as in a project plan?
keen for your thoughts
see sample attached