Countifs Issue while Using Dates

[bigred8051]

I have an issue with my Countifs function. I am looking to calculate the number of entries between certain dates using the function below:

=COUNTIFS($G$80:$G$329,">="&AE103,$G$80:$G$329,"<="&AF103)+COUNTIFS($J$18:$J$51,">="&AE103,$J$18:$J$51,"<="&AF103)+COUNTIFS($J$54:$J$77,">="&AE103,$J$54:$J$77,"<="&AF103)+COUNTIFS(Table_owssvr6[Posting Date],">="&AE103,Table_owssvr6[Posting Date],"<="&AF103)

It seems to be working well except for the fact that it does not count any dates that are the same as the "less than or equal to" parameter. Is there something wrong in the function or am I missing something?

[FlameRetired]

Hi bigred8051. Welcome to the forum.

We are going to need some context with this one.

Please upload an Excel workbook that is representative of what you are working with.

If you are not familiar with how to do this:


To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

[jason.b75]

Best guess would be that your dates are date and time, not just date.

See if this works

=COUNTIFS($G$80:$G$329,">="&INT(AE103),$G$80:$G$329,"<"&INT(AF103)+1)+COUNTIFS($J$18:$J$51,">="&INT(AE103),$J$18:$J$51,"<"&INT(AF103)+1)+COUNTIFS($J$54:$J$77,">="&INT(AE103),$J$54:$J$77,"<"&INT(AF103)+1)+COUNTIFS(Table_owssvr6[Posting Date],">="&int(AE103),Table_owssvr6[Posting Date],"<"&int(AF103)+1)

[bigred8051]

Attached sample issue

[jason.b75]

Dates in column G contain times as well. See post #3.

[bigred8051]

Thanks for the help