如何在Google Sheets中以月年格式,在两个日期之间的列中获取动态月份列表? 例如: Start date: 5/18/2016 End date: 5/24/2019 Jan 2016 Feb 2016 Mar 2016 .. ... May 2019
=ARRAYFORMULA(UNIQUE(TEXT(TO_DATE(ROW( INDIRECT("A"&DATEVALUE(B1)): INDIRECT("B"&DATEVALUE(B2)))), "mmm yyyy")))