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...
aellmanbrown
Your screenshot does not show the row numbers.
spreadsheet formulas work through triangulation, without knowing the row numbers everyone will have to guess your screenshot starts at row 2
with the assumption that your starting at row 2 can you explain to everyone why the datedif function is referencing a start date in C7 and end date in A7 what are the values in those cells so the people on here can make some sense and figure out how the logic works so everyone on here can maybe suggest a better configuration to a bulletproof solution for you.
Your screenshot does not show the row numbers.
spreadsheet formulas work through triangulation, without knowing the row numbers everyone will have to guess your screenshot starts at row 2
with the assumption that your starting at row 2 can you explain to everyone why the datedif function is referencing a start date in C7 and end date in A7 what are the values in those cells so the people on here can make some sense and figure out how the logic works so everyone on here can maybe suggest a better configuration to a bulletproof solution for you.
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.
- That depends on the definition of business day being a workday.
2 functions:
https://exceljet.net/formulas/date-is-workday
Workday function and Wordkay.intl function
These functions must be used in conjunction with datediff
or
Networkdays function and Networkdays.Intl function
https://exceljet.net/formulas/get-workdays-between-dates
Summary
To calculate the number of workdays between two dates, you can use the NETWORKDAYS function.
Hope this helps - 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?
