Create a Microsoft Lists custom calendar
1) Download the Excel file available here
2) Create a new list from Excel and upload the file you've got in the previous step
3) Follow the wizard process to create a new list. Customize the Excel table by assigning the following List column types:
| COLUMN NAME | COLUMN TYPE |
|---|---|
| Title | It's the default Title column |
| DayNumber | Single line of text |
| Month | Single line of text |
| MonthNumber | Single line of text |
| Date | Date and time |
| Event_01 | Single line of text |
| EventColor_01 | Choice |
| Start_01 | Choice |
| End_01 | Choice |
| Event_02 | Single line of text |
| EventColor_02 | Choice |
| Start_02 | Choice |
| End_02 | Choice |
| Event_03 | Single line of text |
| EventColor_03 | Choice |
| Start_03 | Choice |
| End_03 | Choice |
| Event_04 | Single line of text |
| EventColor_04 | Choice |
| Start_04 | Choice |
| End_04 | Choice |
| Event_05 | Single line of text |
| EventColor_05 | Choice |
| Start_05 | Choice |
| End_05 | Choice |
| Event_06 | Single line of text |
| EventColor_06 | Choice |
| Start_06 | Choice |
| End_06 | Choice |
| Event_07 | Single line of text |
| EventColor_07 | Choice |
| Start_07 | Choice |
| End_07 | Choice |
| Favorite | Single line of text |
4) COLOR CHOICES: Apply the color options to the choice columns listed below. These color options will let you choose a color for any new event you want to add into your "calendar".
| EACH CHOICE COLUMN BELOW... | ... MUST CONTAIN THESE OPTIONS BELOW |
|---|---|
| EventColor_01 EventColor_02 EventColor_03 EventColor_04 EventColor_05 EventColor_06 EventColor_07 |
LightSkyBlue Plum Orange LightGreen LemonChiffon LightPink |
 |
For each "EventColor_N" column, you can copy the list of colors above ☝️ and quick paste them as shown in the image. |
5) OPTIONAL STEP - TIME CHOICES: Apply the time options to the choice columns listed below. These options will let you select a start and end time for any new event you want to add into your "calendar". Enable the checkmark to let users fill custom values (e.g. 14:15) You can copy the list of times below and quick paste them as you did in the previous step.
| EACH CHOICE COLUMN BELOW... | ... MUST CONTAIN THESE OPTIONS BELOW |
|---|---|
| Start_01 End_01 Start_02 End_02 Start_03 End_03 Start_04 End_04 Start_05 End_05 Start_06 End_06 Start_07 End_07 |
00:00 00:30 01:00 01:30 02:00 02:30 03:00 03:30 04:00 04:30 05:00 05:30 06:00 06:30 07:00 07:30 08:00 08:30 09:00 09:30 10:00 10:30 11:00 11:30 12:00 12:30 13:00 13:30 14:00 14:30 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:30 19:00 19:30 20:00 20:30 21:00 21:30 22:00 22:30 23:00 23:30 |
6) Create a new Gallery view with name 2022
7) Open the list settings (gear icon in the top right corner), go to the Views section and then select the Gallery view to apply this change: 
8) Copy the JSON code available here
9) Format the gallery view that you've just created and paste the JSON code into the view formatting box (Advanced formatting mode)
10) Go back to the Gallery and use the filter (funnel icon in the top right corner) to create a view for each month selected in the filter pane. After that, you'll be able to select a specific month from the dropdown menù:
