Hi,
Does anyone know how to count dates in column that does not equal to certain year and month?
For eg: I want to calculate the number of dates that do not fall with Mar-2015 (excluding the blank fields).
I tried using the sumproduct function but it gives me error code "#VALUE!"
=SUMPRODUCT(--(TEXT(X5:X14,"yyyymmm")<>(--(TEXT(Z8,"yyyymmm")))))
Month : Mar-2015
<tbody>
</tbody>
Thanks.
<colgroup><col></colgroup><tbody>
</tbody>
Does anyone know how to count dates in column that does not equal to certain year and month?
For eg: I want to calculate the number of dates that do not fall with Mar-2015 (excluding the blank fields).
I tried using the sumproduct function but it gives me error code "#VALUE!"
=SUMPRODUCT(--(TEXT(X5:X14,"yyyymmm")<>(--(TEXT(Z8,"yyyymmm")))))
Month : Mar-2015
End Date |
12-May-2015 |
14-Apr-2015 |
27-Feb-2015 |
24-Mar-2015 |
4-Jun-2015 |
31-Mar-2015 |
<tbody>
</tbody>
Thanks.
<colgroup><col></colgroup><tbody>
</tbody>