Use IFS and WEEKDAY Function to Auto Populate a Calendar

After the user enters a date at the top of the calendar, the IFS (series of IF statements) and the WEEKDAY functions are used to populate the calendar with appropriate days in the appropriate boxes.

Demo file: www.patreon.com/posts/34688830