Excel Gantt Chart - How to #11 – Calendar

XLGantt(Excel Gantt) provides the features to set nonworking days and to set the first day of the week.

On the XLGantt tab in the ribbon, click the "Options" button and then Choose the "Calendar" tab to set options.

1. Set nonworking days

If you set nonworking days, XLGantt excludes them from calculations of working days.

There are three ways to set nonworking days as shown in the illustration below.

1) Saturdays, Sundays, and the dates entered in the Calendar sheet(No need to enter Saturdays and Sundays in the Calendar sheet).

2) Only Saturdays and Sundays(No need to enter Saturdays and Sundays in the Calendar sheet).

3) Only the dates entered in the Calendar sheet.

2. Nonworking days setting in calendar sheet

When setting nonworking days in the calendar sheet, the nonworking days are applied by the calendar as follows.

The standard calendar is applied to all "tasks" and a user-defined calendar is used when nonworking days are applied only to a specific "task".

1) Set nonworking days in the standard calendar

If you select the "Only the dates entered in the Calendar sheet" in the "Days counted as Nonworking day" option and do not set a Calendar in the "Edit a Task" Window, the dates entered in the standard calendar are calculated as nonworking days.

2) Set nonworking days in the user defined calendar

User defined calendar can be applied only to specific "tasks". It is applied as follows.

① Enter specific nonworking days in the user defined calendar.

② Select a "Task" to apply the user defined calendar in the schedule sheet, right-click and select "Edit a Task" from the menu.

Click the Calendar list box in the "Edit a Task" pop-up window, select the specific calendar, and click the Save button.

To see the calendars applied to each task at once, refer to the "Calendar" column. The "Calendar" column is hidden, which you can see by the "Unhide" command.

3) Example of using a user defined calendar

Apply "User defined calendar 1" to the "Coding" task as shown below, and select the option "Saturday, Sunday and the date entered in the calendar sheet" in the Options pop-up.

XLGantt calculates the "coding" task's actual working days as 12 by subtracting 7 nonworking days(Sundays, Saturdays, Company's Founding Day) from 19 days(from 8/19 to 9/6).