SUMIFS with Dates issue

[jb00976]

I am trying to do two formulas:

The first is where it sums anything between K92:K1000 if the dates in F92:F1000 are less than April 30, 2018 here is what I put:

=SUMIFS($K$92:$K$1000,$F$92:$F$1000,"<=30/04/2018")

The second formula I want between two dates for example between May 1, 2018 and May 31, 2018 like this:
=SUMIFS($K$92:$K$1000,$F$92:$F$1000,">=01/05/2018",$F$92:$F$1000,"<=31/05/2018")

I am finding that it is not picking up the last day of the month and I am not sure why. The dates in my formula are in different format to the data (formula DD/MM/YYYY vs data YYYY-MM-DD) but, I don't think that is the issue as it is catching most of the information.

Any help is appreciated.

 

[steve the fish]

What if you do less than 1/6/2018 rather than less than or equal to 31/5/2018?

 

[jb00976]

I know that is an option but, I am more curious as to why it isn't working the way I have it.

 

[steve the fish]

Does that option work? If it does then it's because your dates are not just dates. They have time component.