CODEWITHSUNDEEP
datedynamicgoogle-sheetsauto-populate
Rawland Hustle
Rawland Hustle

Reputation: 781

Fill a column of every other date between to given dates in Google Sheets

How can I have a column dynamically list every other date between a start date and an end date?

Upvotes: 0

Views: 518

Answers (2)

player0
player0

Reputation: 1

this is pretty much universal solution:

=ARRAYFORMULA(FILTER(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2))),
 MOD(ROW(INDIRECT("A1:A"&COUNTA(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2)))))), 2)))

0

Upvotes: 1

player0
player0

Reputation: 1

for odd dates use:

=ARRAYFORMULA(FILTER(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2))),
               ISODD(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2))))))

for even dates use:

=ARRAYFORMULA(FILTER(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2))),
              ISEVEN(TO_DATE(ROW(INDIRECT("A"&A2):INDIRECT("B"&B2))))))

0

Upvotes: 0

Related Questions