Auto create calendar from event data in Excel or Google Sheets

If you have listed data and want to display it as a calendar, Excel & Google Sheets can do that with this process, which I find very useful to use! It uses lots of array functions UNIQUE, SORT and FILTER to give the user control over which dates to see. It also uses a combination of many other formulas: XLOOKUP, TEXTJOIN, IF, IFERROR, TEXT, and more. I showcase this solution in an elegant way
This other video shows some functions used - Dynamic array functions: • 24 Dynamic array funct...
You can download the example files here: www.xlconsulting-asia.com/you...
00:00 Introduction
00:50 Extract weekday name
01:23 Get start of week
02:27 Combining columns
02:48 Expand formulas beyond current data
04:49 Build calendar axes
06:26 Creating the calendar
08:05 Combining in the vertical table
10:17 Fixing NA errors
11:49 Start date filter
13:02 Colour coding
14:22 Changing formula for duplicates
14:50 TEXTJOINIF