Ask Your Question

Find cells with specific month on a column of dates

asked 2015-01-06 17:22:31 +0200

Evangelos Bempelis gravatar image

updated 2015-01-06 17:22:58 +0200

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 on Ubuntu 14.04.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-01-06 18:32:07 +0200

karolus gravatar image

It sounds as you should use →Data→Datapilot|Pivottable....

anyway: SUMPRODUCT works also with nestet Functions:

Something like:

=SUMPRODUCT( MONTH(A1:A100)=1 ; B1:B100 )

should fit your needs.


edit flag offensive delete link more


Yes, indeed MONTH(A1:A100) did the job. I had tried it before but apparently I must have made a syntactic error.

Evangelos Bempelis gravatar imageEvangelos Bempelis ( 2015-01-07 14:17:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-06 17:22:31 +0200

Seen: 805 times

Last updated: Jan 06 '15