Having some issues with the month formula popping up errors when being used as a reference for a range in the collect and countif/countifs functions
The below formula produces an error
=JOIN(COLLECT(Date:Date, Date:Date, MONTH(@cell) = 1))
The below formula returns a 1 even though every day in january is included in the Date column.
=Count(COLLECT(Date:Date, Date:Date, MONTH(@cell) = 1))
The simplest version of what I am trying to do is below, but it also produces an error
I've attached a picture below. Is anyone else having this issue? Anyone come up with a workaround?