Forum Discussion
Auto-populate dates
Hello! I need assistance with automating updates for the remaining dates in the 'Due date' column (Column C). Currently, we use a DateDif formula in Column B to determine the T-weeks schedule, w...
One way to do this is by using formulas in Column C that reference the milestone dates in Column F and the T-weeks schedule in Column B. For example, if the strategy review milestone is in cell F2 and the T-weeks schedule is in cell B2, you could use a formula like this in cell C2:
=F2 + (B2 * 7)
This formula adds the number of weeks specified in the T-weeks schedule to the milestone date, effectively updating the due date accordingly. Then, you can drag this formula down for all the remaining milestones in Column F, and the due dates in Column C will adjust automatically whenever you change a milestone date or the T-weeks schedule. https://clinton-oh.elegantbathroomremodeling.net/