Tag Archive: WORKDAY

Articles sur le thème : WORKDAY

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 …

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/