Formula will not work on last day of month

[john tempest]

=SUMIFS(H16:H250,K16:K250,">="&T10,K16:K250,"<="&U10)

I am using the above formula to look up a date and complete a sum, which works ok until it comes to the last day of the month which it will not record. In this case T10 is the 1st of september and U10 is the 30th of september.
If a month has 31 days it does the same and will not record the 31st. Am I missing something really simple here, but what ever it is I cannot see it
Regards John

 

[Fluff]

Do the dates in col K contain a time element?

 

[john tempest]

Yes it does contain the date and time, this is needed for another calculation on the spreadsheet

 

[Fluff]

In that case you need to use

=SUMIFS(H16:H250,K16:K250,">="&T10,K16:K250,"<"&U10+1)

 

[john tempest]

Thankyou Fluff that works a treat
Regards John

 

[Fluff]

You're welcome & thanks for the feedback.