Filter inline list to current month

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

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()),""))}

7 Likes

Great!!, tks George

1 Like

Thanks George. This works great!!

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

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

1 Like

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

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

1 Like