{"id":21456,"date":"2025-05-19T00:07:54","date_gmt":"2025-05-18T15:07:54","guid":{"rendered":"https:\/\/xlworks.net\/?p=21456"},"modified":"2025-05-19T00:07:54","modified_gmt":"2025-05-18T15:07:54","slug":"xlgantt-howto-11-calendar","status":"publish","type":"post","link":"https:\/\/xlworks.net\/en\/xlgantt-howto-11-calendar\/","title":{"rendered":"Excel Gantt Chart - How to #11 \u2013 Calendar"},"content":{"rendered":"

XLGantt(Excel Gantt) provides the features to set nonworking days and to set the first day of the week.<\/p>\n

On the XLGantt tab in the ribbon, click the \"Options\" button and then Choose the \"Calendar\" tab to set options.<\/p>\n

\"XLGantt(Excel<\/p>\n

 <\/p>\n

1. Set nonworking days<\/h2>\n

If you set nonworking days, XLGantt excludes them from calculations of working days.<\/p>\n

There are three ways to set nonworking days as shown in the illustration below.<\/p>\n

1) Saturdays, Sundays, and the dates entered in the Calendar sheet(No need to enter Saturdays and Sundays in the Calendar sheet).<\/p>\n

2) Only Saturdays and Sundays(No need to enter Saturdays and Sundays in the Calendar sheet).<\/p>\n

3) Only the dates entered in the Calendar sheet.<\/p>\n

\"Set<\/p>\n

 <\/p>\n

2. Nonworking days setting in calendar sheet<\/h2>\n

When setting nonworking days in the calendar sheet, the nonworking days are applied by the calendar as follows.<\/p>\n

\"Nonworking<\/p>\n

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\".<\/p>\n

1) Set nonworking days in the standard calendar<\/h3>\n

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.<\/p>\n

\"Set<\/p>\n

 <\/p>\n

2) Set nonworking days in the user defined calendar<\/h3>\n

User defined calendar can be applied only to specific \"tasks\". It is applied as follows.<\/p>\n

\u2460 Enter specific nonworking days in the user defined calendar.<\/p>\n

\"Set<\/p>\n

 <\/p>\n

\u2461 Select a \"Task\" to apply the user defined calendar in the schedule sheet, right-click and select \"Edit a Task\" from the menu.<\/p>\n

\"Set<\/p>\n

 <\/p>\n

Click the Calendar list box in the \"Edit a Task\" pop-up window, select the specific calendar, and click the Save button.<\/p>\n

\"Set<\/p>\n

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.<\/p>\n

 <\/p>\n

3) Example of using a user defined calendar<\/h3>\n

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.<\/p>\n

\"Example<\/p>\n

\"Example<\/p>\n

 <\/p>\n

\"Example<\/p>\n

 <\/p>\n

 <\/p>\n

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).<\/p>\n

\"Example<\/p>\n

 <\/p>\n

The actual working days become 12.<\/p>\n

\"Example<\/p>\n

 <\/p>\n

 <\/p>\n

3. Set the first day of the week<\/h2>\n

You can set the first day of the week as shown in the following illustration.<\/p>\n

The first day of the week is Sunday by default.<\/p>\n

\"Set<\/p>\n

 <\/p>\n

If the first day of the week is Sunday, Sunday is displayed in the first column of the timescale.<\/p>\n

(Example: July 26, 2020 is Sunday, so it is displayed in the first column of the timescale)<\/p>\n

\"Set<\/p>\n

 <\/p>\n

 <\/p>\n

[ Using XLGantt(Excel Gantt) ]<\/strong><\/p>\n