There is no direct and effective method in sharepoint online to add holidays automatically.
- As a workaround, you could sync the calendar list to Outlook:
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.