I have plotted dates manually on a daily calendar in Excel.
Top two rows have the day and weeks (wk 1,wk 2,wk 3...)
Second calendar is by week - WE date and weeks (wk1, wk2, wk3...)
Commonality is the weeks.
Q1. Can I automate the manual dates input if it's multiple date in a row...
I need to create a Gantt chart that shows how long it is taking to approve construction drawings. I have attached a schedule of the drawings in question with each one having its own reference number and a issue and review date for each revision. I need the Gantt chart to show the time...