Good day to you -



I am using the COUNTIFS function against a single column of data to find the number of events per month.
A typical column entry looks like this - 09/26/2016 7:51 and the cell is formatted as custom mm/dd/yyyy h:mm

The COUNTIFS I am using here is =COUNTIFS(A2:A28,">=09/26/2016",A2:A28,"<=09/30/2016") as there are 28 cells in the column with a September date. Using this function however only nets 21 counts, not 28.

Please open the attached 'for the group.xlsx' and you will see the formula and result.

I have the same issue for October as well and oddly NOV, DEC and January-to-date are correct (not part of the attached). If you wish I can attached the entire sheet but thought if we could resolve this issue with September only then I can apply that to the rest of the sheet.

Please let me know what you think and I thank you for your time on this.

Rob

Attached Files

For the group.xlsx (8.9 KB, 12 views)