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