Excel WORKDAY.INTL - Free Excel Tutorial

Add Workdays in Excel

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 »

Adding Days Exclude Specific Days of Week

As a MS Excel user, you might have come across a situation where you need to add days into the date by excluding specific days of the week. You might have done this kind of task manually, which is an acceptable way to add days into a few dates by excluding specific days. But it… read more »

Excel WORKDAY.INTL Function

This post will guide you how to use Excel WORKDAY.INTL function with syntax and examples in Microsoft excel. Description The Excel WORKDAY.INTL function returns the serial number of the date before or after a specified number of workdays. And this function allow you to exclude weekends and holidays as non-working days. You can use the… read more »

Sidebar