Home > Excel Program > XLGantt > XLGantt How to > XLGantt(Excel Gantt) How to #11 – Calendar

XLGantt(Excel Gantt) How to #11 – Calendar

  • by

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

On the XLGantt tab in the ribbon, Click the "Options" button and then Choose "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.

XLGantt(Excel Gantt) How to - Calendar

 

 

2. Nonworking days setting in calendar sheet

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

XLGantt(Excel Gantt) How to - Calendar

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(Excel Gantt) How to - Calendar

 

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(Excel Gantt) How to - Calendar

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

XLGantt(Excel Gantt) How to - Calendar

 

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

XLGantt(Excel Gantt) How to - Calendar

To see the calendars applied to each task at once, refer to the "Calendar" column. The "Calendar" column is the hidden, which you can see by "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(Excel Gantt) How to - Calendar

XLGantt(Excel Gantt) How to - Calendar

XLGantt(Excel Gantt) How to - Calendar

 

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(Excel Gantt) How to - Calendar

The actual working days becomes 12.

XLGantt(Excel Gantt) How to - Calendar

 

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(Excel Gantt) How to - Calendar

 

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(Excel Gantt) How to - Calendar

 

 

[ XLGantt(Excel Gantt) How to ]

Leave a Reply

Your email address will not be published.