Forum Discussion
aellmanbrown
May 02, 2024Copper Contributor
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...
rikazkhan7
May 03, 2024Copper Contributor
To provide the best assistance, I'd like to understand your current setup a bit better. Could you please provide more details about:
The structure of your spreadsheet, including the columns you're using and any formulas you're currently employing.
The specific behavior you want when a milestone date changes. For example, do you want all subsequent due dates to shift proportionally, or do you have a specific rule for how they should be adjusted?
Any constraints or special cases we need to consider, such as holidays or non-standard working hours.
The structure of your spreadsheet, including the columns you're using and any formulas you're currently employing.
The specific behavior you want when a milestone date changes. For example, do you want all subsequent due dates to shift proportionally, or do you have a specific rule for how they should be adjusted?
Any constraints or special cases we need to consider, such as holidays or non-standard working hours.
- aellmanbrownMay 06, 2024Copper Contributor
Hi there! The only formula I am currently using is DATEDIF in column B. Yes, would like holidays to be considered and the business days only (M-F). If I change May 7th to say May 12th then I would like all subsequent dates in column C to update accordingly.