How to add business Days in a SharePoint Calendar?

Hi All, I want to add business days in our Team SharePoint Calendar. Like For 2018, on 2nd jan it should show BD1 ; and 3 Jan as BD2 and so on. I do not do this manually for whole 2018. Is ther...

SharePoint Online

Matt Coats
Dec 12, 2017
If you know what all of your dates will be ahead of time, you can copy/paste them from Excel into a datasheet view of your Calendar (Chrome won't let you paste that way, but IE will). The only way I saw to switch to your new view in your Calendar is through the Calendar tab, so that's a little awkward but it works fine. I've used this method for mass event creation of ~180 items in a sitting, so it should work for fine for you.

Matt Coats

Iron Contributor

Dec 12, 2017

If you know what all of your dates will be ahead of time, you can copy/paste them from Excel into a datasheet view of your Calendar (Chrome won't let you paste that way, but IE will). The only way I saw to switch to your new view in your Calendar is through the Calendar tab, so that's a little awkward but it works fine. I've used this method for mass event creation of ~180 items in a sitting, so it should work for fine for you.

jcgonzalezmartin
MVP
Dec 12, 2017
The other way around is to add "a business days" layer using client side programming

Forum Discussion

How to add business Days in a SharePoint Calendar?

Resources