Modify formula to insert blank rows into sequence

[kcmuppet]

Hi, I'm using this formula

=WORKDAY.INTL(B42-1,SEQUENCE(10),"0010100")

to create a list of dates thanks to this tip (from Dave Bruns).

With the start date in B42 it produces the dates in a column like this:

Mon 19-Aug
Tue 20-Aug
Thu 22-Aug
Sat 24-Aug
Sun 25-Aug
Mon 26-Aug
Tue 27-Aug
Thu 29-Aug
Sat 31-Aug
Sun 01-Sep


Can anybody think of a way to modify it to insert blank rows after every other like this:

Mon 19-Aug
<blank row>
Tue 20-Aug
<blank row>
Thu 22-Aug
<blank row>
Sat 24-Aug
<blank row>
Sun 25-Aug
<blank row>
Mon 26-Aug
<blank row>
Tue 27-Aug
<blank row>
Thu 29-Aug
<blank row>
Sat 31-Aug
<blank row>
Sun 01-Sep

 

[Fluff]

How about

=TOCOL(EXPAND(WORKDAY.INTL(B42-1,SEQUENCE(10),"0010100"),,2,""))

 

[kcmuppet]

How about

=TOCOL(EXPAND(WORKDAY.INTL(B42-1,SEQUENCE(10),"0010100"),,2,""))

Awesome - thanks @Fluff !

 

[Fluff]

You're welcome & thanks for the feedback.