Tag Archive: WORKDAY

Articles sur le thème : WORKDAY

Add Days Excluding the Weekend

Common error when adding days When you build a schedule for your team, you ususally don’t include the weekend. 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 …

Continue reading

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

Gantt Chart

What is a Gantt chart? A Gantt chart helps you to visualize your project schedule containing different tasks and their deadlines. Your data To create a Gantt chart, you must have a table with: Task names Start dates Effort (number of days needed to carry out each task) Step 1: Return the End Date (based …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/gantt-chart/