google sheets workday - Free Excel Tutorial

Add Workdays in Google Sheets

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 »

Google Sheets WORKDAY Function

This post will guide you how to use Google Sheets WORKDAY function with syntax and examples. Description The Google Sheets WORKDAY function returns a date or a serial number that represents a date that is the indicated number of working days before or after the starting date you specified. You can add a specified number… read more »