Skip to content

Instantly share code, notes, and snippets.

@cassidoo

cassidoo/sundays.txt

Created March 31, 2021 01:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cassidoo/0ca9841f9e3a7a0f4a81d4103d4af277 to your computer and use it in GitHub Desktop.
Save cassidoo/0ca9841f9e3a7a0f4a81d4103d4af277 to your computer and use it in GitHub Desktop.
Download ZIP
Get Sundays in Google Sheets
Raw
sundays.txt
=query(ArrayFormula(TO_DATE(row(indirect("E"&A2):indirect("E"&A3)))),"Select Col1 where dayOfWeek(Col1)=1")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment