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 on YouTube! The first video answers
“What if we aimed Hubble at Earth?” Follow the
What If? channel to be notified about new videos.