Forum Discussion
Count Dates Per Month in a Range of random dates.
I have a range of dates listed below. I want to count the entire list and sometimes this list gets large. for example, the latest list size was from B8 to B612. I would like to have a formul...
=SUMPRODUCT(--(MONTH(B8:B612)=12))
Both formulas work as expected in my sheet.
You can check if all cells in range B49:B612 are empty. If you enter e.g "tomorrow" in cell B222 the formula ( =SUMPRODUCT(--(MONTH(B8:B612)=12)) ) will return the #VALUE error.
Thanks.
The problem ended up being related to the Date type format.
There were only two Date type formats that were not the same as the rest of the Range.
When I changed them to match the rest of the range, it worked fine.
The problem ended up being related to the Date type format.
There were only two Date type formats that were not the same as the rest of the Range.
When I changed them to match the rest of the range, it worked fine.