You'd want to use EOMONTH
function.
For this month, something like (where Dates
refers to your column of dates):
=FILTER(myArray,(Dates>EOMONTH(TODAY(),-1))*(Dates<=EOMONTH(TODAY(),0)))
and for next month:
=FILTER(myArray,(Dates>EOMONTH(TODAY(),0))*(Dates<=EOMONTH(TODAY(),1)))
You'll have to replace myArray
and Dates
with whatever is appropriate for your data.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…