更新时间: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)))