Show dates from the selected range

[Emilian_Bem]

I have a google sheet, with one column that has the dates from the first of January to the last day of December of this year spread out. I have created a slice for this table, I would like this slice to display all the dates from the previous month, the current month and the next month. Can you help me with creating such a formula? Thank you in advance!

[AngeloParana · Accepted solution]

Hello you try this way. 

In security filter of a slice 

OR ( Month([Date_Column])=Month(Today()),

Month([Date_Column])=Month(Today())-1,

Month([Date_Column])=Month(Today())+1)

[Emilian_Bem]

Gold! Thanks a lot!