且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在两个给定日期之间每隔两天自动填充一次

更新时间:2023-01-31 18:15:27

如果开始日期为奇数日期,则该公式似乎跳过了一天.这可以纠正吗?

It seems like the formula skips a day if the start date is an odd date. Can this be corrected?

=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)))