How to count number of entries that fall between two dates

Debbie Petersen

Hi!

I have a sheet that has a date column to enter the initial date of contact. I want to count how many of those entries fall between 2 dates (by month) i.e. I want to know how many of the entries have a date between 1/1/22 and 1/31/22. This is my formula but it's not calculating correctly as I know I have 2 entries with Jan 2022 dates. What have I missed here?

=COUNTIFS({Special Projects Division Master Initial Contact D}, <=(DATE(2022, 1, 1)), {Special Projects Division Master Initial Contact D}, >=(DATE(2022, 1, 31)))

Thanks for the help! As always!!

Brent Wilson

@Debbie Petersen Don't you want...

=COUNTIFS({Special Projects Division Master Initial Contact D}, >=(DATE(2022, 1, 1)), {Special Projects Division Master Initial Contact D}, <=(DATE(2022, 1, 31)))

Debbie Petersen

Sometimes you need another set of eyes! Completely missed I had those backwards! Thank you!

Brent Wilson

@Debbie Petersen Don't you want...

=COUNTIFS({Special Projects Division Master Initial Contact D}, >=(DATE(2022, 1, 1)), {Special Projects Division Master Initial Contact D}, <=(DATE(2022, 1, 31)))

Debbie Petersen

Sometimes you need another set of eyes! Completely missed I had those backwards! Thank you!