Add Workdays in Google Sheets
April 10, 2022
To add or subtract workdays days from a date, respecting holidays but assuming a 7-day week: you can use the WORKDAY.INTL function with an argument that tells it how many days should be subtracted/added as well as which specific holidays to ignore. In our formula below C2 for this example: =WORKDAY.INTL(A2,B2,”0000000″,A7:A8) With this formula, you… read more »