Count based on a date range

bijalvp · July 26, 2024, 6:12am

I have 2 sheets - Summary and MIS-BUY.

MIS-BUY has column A where there are dates listed of a single month from rows 5 to 84

I want to count the number of entries that have dates between the 1st and 5th of the month and display that in a cell in Summary

I tried using Countif but keep getting either False or Err or 30/12/1899

thanks
Entry Count.ods (16.9 KB)

PKG · July 26, 2024, 6:23am

That’s great for you, but the helpers get nothing out of it.
Please upload a corresponding example file.
Thank you.

bijalvp · July 26, 2024, 6:35am

Sorry about that, attached the file (Entry Count.ods) to the original post

PKG · July 26, 2024, 7:02am

I have 2 suggestions for this.

mikekaganski · July 26, 2024, 7:03am

This is because your cells in Summary's column F are formatted as dates.
In addition to @PKG suggestions, Summary.F5 could contain

=COUNTIFS($'MIS-BUY'.A:A;">="&C5;$'MIS-BUY'.A:A;"<="&D5)

bijalvp · July 26, 2024, 7:11am

PGK!!! thank you so much, the pivot table solution is really awesome… im gonna try using that

thanks again

bijalvp · July 26, 2024, 9:33am

As as aside - how did you get the dates in the pivot table into weekly ranges?

thanks

PKG · July 26, 2024, 9:39am

I grouped (F12) the date column.