I have a column with dates, say A1:A10
, and I want to check which dates are January, e.g. MONTH(A1) = 1
. However, I don’t know how to use MONTH
function on an array, if such thing is possible. I need to produce an array of TRUE/FALSE
, so that I can later use it with SUMPRODUCT
.
I am using LibreCalc 4.2.7.2 on Ubuntu 14.04.