Spreadsheets

Spreadsheets

(alt-text)

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.

What If? is now on YouTube!
Check out the first video for the answer to
“What if we aimed the Hubble Telescope at Earth?”
and follow xkcd’s What If? The Video Series channel to be notified about each new video.