Automation of Start Date
We are currently looking for a way to manually adjust "Start Date" and "End Date" columns that are tied to predecessors and durations. Our goal is to adjust these dates from Reports or Task Lists that pull the tasks, data, and dates from multiple Worksheets. Currently, we cannot auto-adjust these dates due to the formulas tied into the cells. We have been populating a third column for dates, which then requires opening each sheet for later adjustment.
Is there a workaround where we can populate that the "Start Date" column with the "End Date" still following the duration? This would greatly reduce time spent adjusting sheet by sheet, and would greatly aid in the calendar function and adjustment within individual reports and task lists. Thanks!