Sequencing dates that skip a blank row and date
I'm using Sheets to track my worked hours, and trying to use a formula to list the dates rather than enter manually.
I work 6 days a week and skip Sundays, so I have the sheet split into blocks of 6 rows (days), with a blank row in between to act as a visual spacer.
I tried using ;
=SEQUENCE(7,1,DATE(2026,5,25),1)
But that fills all 7 days of the week, ignoring the blank row and putting Sunday's date on it.
That would be fine, but I'd really like to keep that blank row as a visual spacer.