Excel WBS and Gantt Chart - XLGantt 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.

XLGantt - Setting nonworking days

 

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.

XLGantt - Setting nonworking days

 

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.

XLGantt - Setting nonworking days

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.

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

XLGantt - Setting nonworking days

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

XLGantt - Setting nonworking days

 

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

XLGantt - Setting nonworking days

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 - Setting nonworking days

XLGantt - Setting nonworking days

 

XLGantt - Setting nonworking days

 

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

XLGantt - Setting nonworking days

The actual working days become 12.

XLGantt - Setting nonworking days

 

3. Set the first day of the week

You can set the first day of the week as shown in the following illustration.

The first day of the week is Sunday by default.

XLGantt - Setting nonworking days

 

If the first day of the week is Sunday, Sunday is displayed in the first column of the timescale.

(Example: July 26, 2020 is Sunday, so it is displayed in the first column of the timescale)

XLGantt - Setting nonworking days

 

[ XLGantt(Excel Gantt) How to ]

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top