Calendar Setup

Ribbon location: DVD Cons tab → Schedule group → dialog launcher (Gantt setup) → Calendar Setup tab

Command ID: btnCalendarSetup

What it does

Declares which weekdays are working days and which dates are holidays. This is a shared source, not a per-command setting: six features read it.

Feature	What it uses the calendar for
Draw Gantt	Shading non-working days and holidays
CPM engine	Counting working days when rolling out start / finish dates
Schedule recovery	Variance against the plan
EVM report	Building the PV time series
Variance dashboard	Converting slipped days
3-week lookahead	Spreading work over workable days

How to use it

1. Open the Calendar Setup tab.
2. Tick the weekdays that are working days (Vietnam default: Monday to Saturday).
3. Add holidays to the table below — one date per row, with a tick box so you can disable a date without deleting it.
4. Click Save. From 2.8.4 the schedule is recalculated and redrawn immediately on the active sheet — no need to click Draw Gantt afterwards.

Notes

• The calendar is stored in two places: inside the workbook itself (so it travels with the project) and in your machine settings (used for workbooks that carry none). A workbook's own calendar wins.
• It is also mirrored into the LichLamViec / DSNgayLe named ranges, so older sheets whose formulas read those ranges keep working.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Cài đặt tiến độ, Mẫu, Ngôn ngữ tiêu đề · 6 min 52 s · 15 cases · Download the video · Practice workbook for the video

Commands in this video: Setup · Calendar Setup · Gantt Tpl · Header Language

Chapters (19)

1. Giới thiệu
2. Mở lệnh
3. 1 · Đổi tiêu đề Anh → Việt
4. 2 · Bảng lẫn hai thứ tiếng
5. 3 · Bảng không phải tiến độ
6. 4 · Cửa sổ Cài đặt – ba thẻ
7. 5 · Hiển thị, màu, thang
8. 6 · Đường găng
9. 7 · Từ khoá tài nguyên
10. 8 · Tuần làm việc 5 ngày
11. 9 · Ngày lễ, ngày nghỉ riêng
12. 10 · Lưu theo sổ hay theo máy
13. 11 · Ẩn/Hiện cột
14. 12 · Sắp xếp cột, Ctrl+Z
15. 13 · Mẫu tiến độ → sổ mới
16. 14 · Không tìm thấy mẫu
17. 15 · Sheet đang khoá
18. Mẹo
19. Kết thúc