Forum Discussion

Rajender Mehra's avatar
Rajender Mehra
Copper Contributor
Dec 12, 2017
Solved

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 there a method I can do it at one time, Like writing down them in Excel and then uploading it to SharePoint Calendar. I know it is possible. Please let know the exact method. I do not want to Spoil my calendar by experimenting.

I have attached the sample as attachement, help it will explain my concern better.

Please help :) 

Thanks,

Rajender

SharePoint Online
  • Matt Coats's avatar
    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.

2 Replies

  • Matt Coats's avatar
    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.

Resources