Is it possible to add public holiday in SharePoint Calendar?

Wang 41 Reputation points


We created in SharePoint the team calendar. As the team member stays in different countries, we would like to see the public holiday showing on the calendar. Is it possible? At the moment, we are adding the public holiday manually, like showed in the attached picture. Is there any automatic way to add?
Thank you very much for your help! BR Ying


SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,450 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,003 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
1,671 questions
No comments
{count} votes

Accepted answer
  1. Yi Lu_MSFT 16,676 Reputation points Microsoft Employee

    Hi @Wang
    There is no direct and effective method in sharepoint online to add holidays automatically.

    1. As a workaround, you could sync the calendar list to Outlook:


    2.Then add holidays to your calendar in Outlook for Windows

    3.After you add all the holidays to your Outlook calendar, open up the SharePoint Calendar in Outlook - Drag and Drop the events from Outlook to the SharePoint Calendar in Outlook.
    Holidays added to SharePoint Group Calendar through Outlook will be synced immediately.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful