Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can make a calendar view from list data in the Lists app—or from list or library data in SharePoint in Microsoft 365. Any list or library that has a date column can be viewed in calendar format. 

To create a calendar based on new data, start with the first procedure below. 

If you already have a list or library that includes dates in it, skip down to Create a calendar view.

Create a blank list

  1. From the home page of the Lists app in Microsoft 365, select +New list.

    Or, on your SharePoint site, select +New > List

  2. Under Create a list, select Blank list.

Add date columns and other columns you need to the list

  1. To the right of the last column name at the top of the list or library, select + Add column or +.

  2. In the menu that appears, select the type of column you want. You'll need at least one Date and time column. 

  3. In the Create a column panel, in the Name field, enter a title or column heading.

    Create a "Date and time" column.

  4. Enter any other required information. The number of boxes to fill will vary with type of column you choose. The above example is for a 'date' column.

  5. Repeat steps 2 through 4 until you have all the columns you want for your list. 

Add some data to the list

With your columns defined, add one or two sample items to the list so that you can see how they look shortly when you turn the list into a calendar. 

  1. On the Command bar, select Edit in grid view.

  2. Enter the necessary information for each list item.

  3. When you're done, select Exit grid view.

Create a calendar view and set it as the default view

  1. On the upper right-hand side of the command bar, select the View options menu:

    View options menu

  2. Select Create new view.

  3. Under View name, enter a name.

  4. Under Show as, select Calendar as the type of view you want to create.

  5. Under Start date and End date, select which date-based column or columns should apply.

    Choose a start and end date

    If you are only keying on one date, just specify that date column for both Start date on calendar and End date on calendar. But if you have two dates to track (such as "project start" and "project completion"), you can specify one each under Start date and End date. The effect will be that each calendar item in your list will be represented on the calendar as a span of days rather than a single date. 

  6. Under More options, you have the ability to select which column in your list is used as the label for each that appears on the calendar. By default, Title is used, but you can change that if you like. 

  7. Select Create

The items in the list are now displayed as calendar events.  Click on a day that has an event. The details of the events from that day are shown in the panel on the right.

Make the calendar view the standard view

  1. Select the View options menu on the right end of the command bar:

    Save the calendar view as the default view.

  2. Select Set current view as default

From now one, when you or your co-workers open the list, it will be shown as a calendar. People can view and create items in this view. 

Customize a "Date and time" column

You can customize a Date and time column in these ways:

  • Include only the date or both the date and time: Specify whether you want to include only the calendar date or both the calendar date and time of day.

  • Display a default value: Automatically display a specific date or date and time when someone adds a new item, while also allowing people to enter a different value if they need to do so. A default value helps people enter information faster. For example, if the column stores the date when an expense is incurred and most expenses are incurred on the first day of the fiscal year, you can specify the first day of the fiscal year as the default value. As a result, that date appears automatically when a new item is added to the list, and team members do not have to enter the date.

    A default value can be a value that you specify, the date an item is added to a list or library, or the result of a calculation, which is called a calculated value. Calculated values are helpful when you want to display a specific date or time automatically but the date or time might vary depending on the item. To use a calculated value, you enter a formula as the default value. The formula can calculate a value based on information in other columns or system functions such as [today], to indicate the current date. For example, if you want the column to display a date that is 30 days after the current date, type the equation =[TODAY]+30 in the Calculated Value box.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!