Countifs formula is not working correctly

[hofst038]

Date	Lead Tech	Non Lead Tech	Completed
3/11/2016			Y
3/15/2016			N
3/16/2016			N
3/17/2016			Y
3/20/2016			N

<tbody>
</tbody>

So I want a count of all the “Y” values in the Completed column based off the date range of 3/11/2016-3/18/2016.

My formula goes like this: =COUNTIFS($A$1:$A$6, ">=" &DATEVALUE("3/11/2016"),$A$1:$A$6, "<="&DATEVALUE("3/18/2106"),$D$1:$D$6, "Y")

It seems to be ignoring the formula and grabbing ALL dates that are 3/11/2016 and above, not just the ones in the selected date range 3/11/2016-3/18/2016. Does anyone know how to fix this so it grabs only the dates from 3/11/2016 to 3/18/2016?

 

[dave3009]

Did you mean to set the second date as 2106?

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...lumn-based-off-date-range-another-column.html

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

Not sure why you did that anyway, since we are helping you out on that thread!