✦Template Printable Ideas Insights

2026 Singapore Holidays Calendar for Excel

By

If you're planning your 2026 calendar and wondering about the public holidays in Singapore, you've come to the right place. This comprehensive guide will help you create an Excel calendar that includes all the important dates you need to know.

Singapore follows a unique calendar system where some dates are fixed while others move around. Let's dive into understanding these holidays and how to set them up in your Excel calendar.

Understanding Singapore's Public Holidays

Singapore has 11 public holidays, and most are based on the lunar calendar. The dates shift each year, so it's crucial to update your calendar annually.

πŸ‡ΈπŸ‡¬ πŸ“… Singapore 2026 Printable Calendar
πŸ‡ΈπŸ‡¬ πŸ“… Singapore 2026 Printable Calendar
FREE Calendar & Planner Excel Template for 2026
FREE Calendar & Planner Excel Template for 2026
Excel Calendar 2025 with 25 designed layouts - Free Download
Excel Calendar 2025 with 25 designed layouts - Free Download

To give you a head start, here are the public holidays for 2026, which we'll use as a reference for creating your Excel calendar:

  • New Year's Day: January 1, 2026
  • Chinese New Year: January 29, 2026
  • Good Friday: April 10, 2026
  • Labour Day: May 1, 2026
  • Hari Raya Puasa: May 2, 2026
  • Vesak Day: May 30, 2026
  • National Day: August 9, 2026
  • Hari Raya Haji: July 18, 2026
  • Deepavali: November 3, 2026
  • Christmas Day: December 25, 2026

Fixed Public Holidays

Some public holidays in Singapore have fixed dates. These include New Year's Day, Labour Day, National Day, and Christmas Day. You can safely input these dates in your Excel calendar without worrying about changes.

Editable 2026 Calendar With with Holidays
Editable 2026 Calendar With with Holidays
2026 Calendar with Holidays and Observances - United States
2026 Calendar with Holidays and Observances - United States
Excel Calendar Template 2026 (Editable Free XLSX Download)
Excel Calendar Template 2026 (Editable Free XLSX Download)

Here's how you can format these dates in Excel: - Select the cell where you want to enter the date. - Type "01/01/2026" (no quotes, without the dashes) and press Enter. - Repeat for the other fixed dates.

Variable Public Holidays

The rest of the public holidays in Singapore are based on the lunar calendar or other variable factors. To include these in your Excel calendar, you'll need to update the dates each year or use a tool that automatically updates these dates for you.

You can find several online tools and apps that generate an Excel calendar with Singapore's public holidays based on the latest information. Downloading one of these calendars can save you time and ensure you always have the correct dates.

2026 Planner | Free PDF Templates
2026 Planner | Free PDF Templates
Team Vacation Calendar 2026-2030 - Editable Excel Leave Tracker (Digital Download)
Team Vacation Calendar 2026-2030 - Editable Excel Leave Tracker (Digital Download)
Printable monthly 2026 calendar with France holidays
Printable monthly 2026 calendar with France holidays
πŸ“… 2026 Printable Calendar | Colorful Yearly Planner | Full Year Calendar 2026 | Monthly Calendar
πŸ“… 2026 Printable Calendar | Colorful Yearly Planner | Full Year Calendar 2026 | Monthly Calendar
2026 U.S. Calendar with Holidays – Color-Coded Yearly Planner Template
2026 U.S. Calendar with Holidays – Color-Coded Yearly Planner Template
was this helpful for you?
was this helpful for you?

Creating Your Excel Calendar

Now that you understand Singapore's public holidays, let's create your 2026 calendar in Excel.

Here's a step-by-step guide to help you get started:

Setting Up the Basic Calendar

1. Open a new Excel file and select a date (e.g., 01/01/2026).

2026 Calendars – Full Year PDF Printables | EntheosWeb
2026 Calendars – Full Year PDF Printables | EntheosWeb
Free 2026 Calendars
Free 2026 Calendars
a calendar for the new year is shown in this printable version, which includes holidays and
a calendar for the new year is shown in this printable version, which includes holidays and

2. Click and drag to highlight the dates you want to include in your calendar (e.g., from 01/01/2026 to 31/12/2026).

Formatting the Calendar

1. Right-click on the selected dates and choose "Format Cells" (or press Ctrl + 1).

2. Under the "Number" tab, select "Custom" in the "Category" list.

3. In the "Type" field, enter "ddd mmm dd" (without the quotes) and click OK.

Finally, don't forget to manually update your Excel calendar each year or use an automatic tool to ensure your public holidays are always correct. Now, you're all set to plan your year in 2026 with confidence!