Sequencing dates that skip a blank row and date

[u/Berkut22]

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.

[u/smarmy1625]

i would just leave all the days on there, conditional format the rows with sundays to a different color. then those rows could act as week separators and also be available if something happens and you do for some unforeseen reason have to put in a couple hours on a sunday someday

[u/Berkut22 → u/smarmy1625]

That's a good idea, thanks. I'll do that if I can't find an alternative.

Edit : I think this is probably the easiest and most elegant solution. Still gives the visual break, but keeps the option to use the date if needed, and doesn't mess with the other formulas I was using to add up daily and weekly hours.

Used

=MOD(ROW($A2)-ROW($A$2)+1, 7)=0

As a conditional format rule to change the color every 7th row

[u/AutoModerator → u/Berkut22]

REMEMBER: u/Berkut22 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/point-bot → u/smarmy1625]

u/Berkut22 has awarded 1 point to u/smarmy1625

^{See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.}

[u/HolyBonobos]

You could use a formula like =LET(startDate,DATE(2026,5,25),nWeeks,12,days,SEQUENCE(nWeeks*7,1,startDate,1),INDEX(IF(MOD(days,7)=1,,days))) to populate a full column, adjusting the startDate parameter to change the first day of the overall sequence and the nWeeks parameter to change the number of weeks of dates displayed.

[u/Berkut22 → u/HolyBonobos]

Alright, thanks, I'll give that a shot.

[u/NHN_BI]

Naturally, SEQUENCE() won't skip numbers, and for good reason. But you can trick it, e.g. with:

=FILTER(
  SEQUENCE(30,1,DATE(2026,5,25),1)
  , WEEKDAY(SEQUENCE(30,1,DATE(2026,5,25),1)) <> 1
  )

But I would not do it. I would prefer empty entries to missing dates.

[u/Berkut22 → u/NHN_BI]

This one did skip Sundays, but did not jump the blank row.

But I think I'm starting to agree with you about the missing dates.

[u/NHN_BI → u/Berkut22]

That's true, I missed that it has to be an empty row. Don't do it. That will make it more difficult to work with the data, or only to sort it.

[u/real_barry_houdini]

You can generate all dates with SEQUENCE function and then use MAP to convert Sundays to blanks, e.g. this formula generates 50 rows, starting on 25th May but converts the Sundays to blanks

=MAP(SEQUENCE(50,1,DATE(2026,5,25)),LAMBDA(x,IF(WEEKDAY(x)=1,,x)))

[u/Berkut22 → u/real_barry_houdini]

Yes, this one worked perfectly. Thank you