COUNTIF formula

I am trying to count the number of projects completed between July 1, 2018 and June 30, 2019 with this formula:

=COUNTIFS({Status}, ="Completed", {Completion Date}, >=DATE(2018, 7, 1) <= DATE(2019, 6, 30))

The outcome is supposed to be 6, but it is reading back 7 (it is also counting San Antonio). Does anyone know why??

Find more posts tagged with

Formulas

Attachments

I think you need to specify a range for both dates. Try this:

=COUNTIFS({Status}, ="Completed", {Completion Date}, >=DATE(2018, 7, 1), {Completion Date}, <= DATE(2019, 6, 30))

Thank you! This worked

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.