293Holidays
Public, substitution and company holidays. Recurring ones count every year.
Try it
Calendar & working days
Weekends + holidays are days off; recurring holidays repeat every year| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| 26 | 27 | 28 | 29 | 30 | 31 | 1 |
| 2 Company Sports Day | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 1 | 2 | 3 | 4 | 5 | 6 |
Add working days
10 working days after 2026-11-09 β
Mon 23 Nov 2026
Count working days
20working days (both dates included)
Holidays this month
2026-11-02 Company Sports Day
| # | Date | Name | Type | Every year | Status | |
|---|---|---|---|---|---|---|
| 1 | 2026-01-01 | New Year's Day | Public holiday | β | Active | βοΈ |
| 2 | 2026-03-03 | Makha Bucha Day | Public holiday | Active | βοΈ | |
| 3 | 2026-04-06 | Chakri Memorial Day | Public holiday | β | Active | βοΈ |
| 4 | 2026-04-13 | Songkran Festival | Public holiday | β | Active | βοΈ |
| 5 | 2026-04-14 | Songkran Festival | Public holiday | β | Active | βοΈ |
| 6 | 2026-04-15 | Songkran Festival | Public holiday | β | Active | βοΈ |
| 7 | 2026-05-01 | National Labour Day | Public holiday | β | Active | βοΈ |
| 8 | 2026-05-04 | Coronation Day | Public holiday | β | Active | βοΈ |
| 9 | 2026-06-01 | Substitution for Visakha Bucha Day | Substitution day | Active | βοΈ | |
| 10 | 2026-06-03 | Queen Suthida's Birthday | Public holiday | β | Active | βοΈ |
| 11 | 2026-07-28 | King Vajiralongkorn's Birthday | Public holiday | β | Active | βοΈ |
| 12 | 2026-07-29 | Asarnha Bucha Day | Public holiday | Active | βοΈ | |
| 13 | 2026-08-12 | Mother's Day | Public holiday | β | Active | βοΈ |
| 14 | 2026-10-13 | King Bhumibol Memorial Day | Public holiday | β | Active | βοΈ |
| 15 | 2026-10-23 | Chulalongkorn Day | Public holiday | β | Active | βοΈ |
Showing 1β15 of 20
π Learn: how this master is built table holiday
Key points
- HolidayService.addWorkingDays(): skip Saturdays, Sundays and holidays.
- DATE column β java.time.LocalDate (no time zone problems).
Code
- Entity
domain/Holiday.java- Repository
repo/HolidayRepository.java- Definition
MasterRegistry: "holidays"- Page / form
web/MasterController.java- Try-it panel
templates/tools/holiday-calendar.html- REST API
GET /api/holidays/working-days?from=2026-10-01&to=2026-10-31
SQL to try in SSMS (database MasterDataLabDB)
SELECT holiday_date, DATENAME(WEEKDAY, holiday_date) AS weekday, name FROM holiday WHERE YEAR(holiday_date) = 2026 ORDER BY holiday_date;