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...
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.
In order for that to happen, then the values in column A should be calculated in order for the subsequent values to dynamically change up to the next constant value in column C, assuming the subsequent values in column C after May 7 are also calculated dates (its complicated)
I would guess that you might need a calendar table to base your event date column to dynamically adjust on the basis of the entry in the Due date in column C so that when you enter a constant date in column C, the event date will adjust accordingly by calculating the dates in column A to move relative to the constant value in column C on the previous row. (I'm assuming since I do not know the algorithm of the logic on your table)
You would have to explain the movement of any dates on the current row as well as the next row in order for the people on here to catch on to the algorithm date movement.
for example if you changed May 7 to May 12, will the date in column A same row change? (I assume not since your narrative is slanting to move forward hence I can safely assume that the date in column A next row would change?
I would guess that you might need a calendar table to base your event date column to dynamically adjust on the basis of the entry in the Due date in column C so that when you enter a constant date in column C, the event date will adjust accordingly by calculating the dates in column A to move relative to the constant value in column C on the previous row. (I'm assuming since I do not know the algorithm of the logic on your table)
You would have to explain the movement of any dates on the current row as well as the next row in order for the people on here to catch on to the algorithm date movement.
for example if you changed May 7 to May 12, will the date in column A same row change? (I assume not since your narrative is slanting to move forward hence I can safely assume that the date in column A next row would change?