Calvin_And_Hobbes: 2019-07-25.1

Garfield: 2019-07-25.1

Wizard_of_Id: 2019-07-25.1

Dilbert: 2019-07-25.1

Ruthe: 2019-07-25.1

BC: 2019-07-25.1

xkcd: "Spreadsheets" 2019-07-24.1

My brother once asked me if there was a function to produce a calendar grid from a list of dates in Google Sheets. I replied with a single-cell formula that took in a list of dates and outputted a calendar. It used SEQUENCE(), REGEXMATCH(), and a double-nested ARRAYFORMULA(), and it locked up the browser for 15 seconds every time it ran. I think he learned a lot about asking me things.


← Prev Day       ↑ up ↑       Next Day →