Filter inline list to current month

Ask for Help
1

Hey,
I need to filter in the inline list (modo calendar) only the current month, how do I do it?

calendar
calendar395×594 17.9 KB

2

Put this formula on row 1 of a column on your sheet. Change the F2:F to the column you have your date in. Then filter on this column.

={"ThisMonth";ARRAYFORMULA(IF(LEN(F2:F),month(F2:F)=month(today()),""))}

1208×314 24.7 KB

3

Great!!, tks George

4

Thanks George. This works great!!

5

George,
How would I modify this formula for the current date instead of the month? Thanks

6

I haven’t tested it but I’m pretty sure… just take out both occurrences of the word month.

7

Well that was simple. I tried everything but that. Thanks it works perfectly

8

Glide also has built in filtering to compare dates to Today…in case you are interested in a non formula solution.