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.
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
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
