How do i get a date in a spreadsheet to populate a Calendar View

I am setting up a university addmissions spreadhsheet to help me keep track of deadlines. If I put dates in my spreadsheets (in multiple columns) - how do i get it to auto-populate my calendar view in the workbook? Cant seem to find anything that automates this?

Hi @Erica_House, Welcome to

In Calendar View, you can click the “Using dates” button in the header to open the date selector dialog. From here you can configure the Start date and End date for the calendar view (see screenshot 1).

After configuring the dates, all sheet rows/records with selected dates are shown as events in the calendar view (see screenshot 2).


Help documentation: