Add days without the weekend

Common error when adding days

When you build a schedule for your team, you mustn't include the weekend in your result.

So you can't write a formula like this

=B2+C2

Look at the first results! 🧐🧐🧐

Even if the first result looks correct, it isn't. The result is Monday but it should be Wednesday. If you add 3 work days to Friday, you must skip Saturday and Sunday.

Format of the date

As you can notice, you can easily see if the result is a Sunday or a Monday just by reading the result in the cell.

How this is possible?

Well, it's simple. I customize the format of the date to return the day in word and in number. Look at this post to learn how to customize your date.

Skip the weekends

If you want to skip the weekend, there is one function who do that very well. It's the function WORDAY

The function WORKDAY has 2 parameters.

  • First parameter, it's a date
  • Second parameter, the number of days to add

So in our example, we just have to write this formula in our cells.

=WORKDAY(B2,C2)

Arabic weekend

The function WORKDAY consider that the weekend is Saturday and Sunday. But there is some countries in the world like Saudi Arabia, Algeria, and some Gulf countries where the weekend starts on Thursday and finish on Friday.

If you work in this part of the world or if you work with this countries, it important to calculate properly the weekend.

In that case, you use the function WORKDAY.INTL

The first 2 parameters are the same as the function WORKDAY. But here, you have a third parameter where you specify which days are the weekends.

So, in this case, you have to selection the option 6.

 

 

Apply to our document, we have now this result.

As you can noticed, for the same date and a difference of 1 day, the result is different in column D.

 

Related posts


Permanent link to this article: https://www.excel-exercise.com/add-days-without-weekend/


Leave a Reply

Your email address will not be published.