Countif in date interval

Hi,

Issue:
The input comes from a list in our CRM system. How can I count in between a date interval in this example?
As an example I want to calculate how many days they where online in between 01.10.2018-31.10.2018? (The correct answer is of course 10 here)

Do anyone have a formula for this? I only want to count in month.
Do I have to transform the date cell first before I can count it? In that case, how?

The input is like this:
06.02.2018 13.00.01
07.03.2018 14.59.50
09.05.2018 10.27.22
22.06.2018 13.55.18
22.06.2018 14.07.18
30.07.2018 08.55.28
18.09.2018 12.59.21
17.10.2018 14.31.21
31.10.2018 12.25.25
31.10.2018 12.26.58
31.10.2018 12.28.42
31.10.2018 12.30.39
31.10.2018 12.33.04
31.10.2018 12.34.47
31.10.2018 12.36.16
31.10.2018 12.38.00
31.10.2018 13.23.10
13.11.2018 13.40.16
29.12.2018 19.55.46

Thanks for all help!

There a few routes you could take, one might be:

Formula:

Please Login or Register  to view this content.

you can modify the above to do a between range:

Formula:

Please Login or Register  to view this content.

where B1 holds 01-Oct and B2 holds 31-Oct

Originally Posted by XLent

There a few routes you could take, one might be:

Formula:

Please Login or Register  to view this content.

you can modify the above to do a between range:

Formula:

Please Login or Register  to view this content.

where B1 holds 01-Oct and B2 holds 31-Oct

Thanks a lot!!

Hmm.
I manage do do it in October.
But when when i try to it for example for June it does not work.
What do I do wrong?

=SUMPRODUCT((SUBSTITUTE(LEFT(A1:A19,6),".","-")+0>=B1)*(SUBSTITUTE(LEFT(A1:A19,6),".","-")+0<=B2))

B1 = 1-June
B2 = 31 June

The reference to 10 in the LEFT function is telling XL how many characters to look at in the strings in Column A (it then converts these to a date value courtesy of +0), it is not related to the month #

so, if you change your references above to 6 back to 10 it should work ok.

Thanks!
Now it worked fine.