# Company holiday calendar in SharePoint for 2027

> For the full documentation index, see https://250highstreet.com/llms.txt

> Build a company holiday list in SharePoint, show it as a calendar view, and keep the dates in one place your flows can read. Steps included.

Short answer: make a SharePoint list with a Date and time column, then add a view that shows it as a calendar. Microsoft's page says: "Any list or library that has a date column can be viewed in calendar format."

## What you are building

One list called "Company Holidays". One row per day off. Your team opens the list, sees a month grid, and your flows can read the same rows later. I use placeholders below. Fill in your own 2027 days from your own policy.

## Step 1. Make the list

Start from a new list in your Microsoft 365 site. Exact names may differ on your screen. These are the columns I add.

1.  Title: the name of the holiday, such as "Holiday name 1".
2.  Holiday date: a Date and time column. Microsoft's page says you need "at least one Date and time column".
3.  Observed by: a Choice column such as All staff, Warehouse only, Office only. Our advice, not a Microsoft rule: only add it if your days off differ by group.
4.  Year: a Number column or Choice column set to 2027. Our advice, not a Microsoft rule: it lets you filter next year's rows out later.

Add one row per day off. Leave the dates as your own. I do not list holiday dates here because your policy sets them.

## Step 2. Add the calendar view

These are the steps from Microsoft's page.

1.  On the upper right of the command bar, select +Add view.
2.  Under View name, enter a name, such as "Calendar".
3.  Under Show as, select Calendar.
4.  Under Start date and End date, pick the columns. Microsoft says for a single date to "just specify that date column for both Start date on calendar and End date on calendar."
5.  Under More options, choose which column labels each item. The default is Title.
6.  Select Create.

For a holiday that spans days, such as a long closure, add a second Date and time column named "Last day off". Microsoft says two date columns make each item show as "a span of days rather than a single date."

## Step 3. Make the calendar the first thing people see

1.  Select the name of the view you just made to see its settings.
2.  Select Set current view as default.

Microsoft's page says: "From now on, when you or your co-workers open the list, it will be shown as a calendar."

## Show holidays next to another calendar

Calendar overlay belongs to the classic calendar. Microsoft's overlay page applies to SharePoint Server 2010, 2013 and 2016, and says: "you can add up to four Exchange or SharePoint calendars." It does not cover the calendar view of a modern list. If you use the classic calendar and the overlay does not show, see "[SharePoint calendar overlay not showing](/guides/sharepoint-calendar-overlay-not-showing/)".

## Use the same list to skip holidays in a flow

Our advice, not a Microsoft rule: keep one list and let flows read it, so nobody keeps a second set of dates.

1.  In Power Automate, use the SharePoint action Get items on the Company Holidays list. Set a filter on Holiday date for the range you need.
2.  Set Top Count. The default limit of Get items is 100, and Top Count goes up to 5,000. Turn Pagination on if you need more than 100 rows.
3.  Add a Condition that checks whether the date you want is in the result. If it is, move to the next day.

For adding working days, see "[Add business days to a date in Power Automate](/guides/power-automate-add-business-days-to-date/)". For a team time-off list, see "[Time-off requests lost in email](/guides/time-off-requests-in-email/)". This page is holidays only.

## What to avoid

- Do not type holidays into each person's own Outlook. One list is the source.
- Do not store the date as text. A calendar view needs a Date and time column.
- Do not publish 2027 rows until you have confirmed the dates with your own policy.
- Our advice, not a Microsoft rule: add rows for the new year before the old year ends, and filter on the Year column.

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

### How do I make a holiday calendar in SharePoint?

Make a list with a Date and time column, then select +Add view and set Show as to Calendar.

### Can SharePoint show public holidays automatically?

Microsoft's calendar view pages describe no automatic holiday feed. Add the holidays as rows in a list.

### How do I show a SharePoint list as a calendar?

Select +Add view, set Show as to Calendar, then choose the Start date and End date columns.

### Can a holiday that lasts several days show as one bar?

Yes. Microsoft says two date columns make each item show as "a span of days rather than a single date."

### How do I open the list as a calendar every time?

Open the view settings and select Set current view as default.

## Sources

- [Microsoft Support, Create a calendar view from a list](https://support.microsoft.com/en-us/sharepoint/lists/create-a-calendar-view-from-a-list)
- [Microsoft Support, Overlay a SharePoint calendar with a calendar from Exchange or SharePoint](https://support.microsoft.com/en-us/sharepoint/lists/overlay-a-sharepoint-calendar-with-a-calendar-from-exchange-or-sharepoint)

## Related guides

- [Content calendar in SharePoint](/guides/content-calendar-sharepoint/)
- [SharePoint calendar overlay will not show another list](/guides/sharepoint-calendar-overlay-not-showing/)
- [Outlook shared calendar or SharePoint calendar for a team](/guides/outlook-shared-calendar-vs-sharepoint-calendar/)

Source: https://250highstreet.com/guides/sharepoint-company-holiday-calendar/