#2180: Spreadsheets
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.

Wednesday, July 24, 2019
Download archive
All material contained herein © Randall Munroe (license)
Site layout, design, and code © 2024 Sean Helling