Count cell with different date and year exist

Hi,,

I need to count number of a different date in a cells, but I just want to count it as a one if there is a same date in a cell.

Is there any formula to fix it, Mr bebo help me with just one year, what if i want to make it monthly/year.


Thanks,

I already attachh the example.

Is this still for Excel 2016?

Try this:

=SUMPRODUCT(($A$3:$A$42>=(DATE(YEAR(E3),MONTH(E3),1)))*($A$3:$A$42<=E3))

You have just shifted the goalposts!

Do you still have Excel 2016 or something newer?

I use Excel 2016

Thanks for comfirming.

Try this:

=SUM(IF($A$3:$A$42>=(DATE(YEAR(E3),MONTH(E3),1)),IF($A$3:$A$42<=E3,1/(COUNTIFS($A$3:$A$42,">="&(DATE(YEAR(E3),MONTH(E3),1)),$A$3:$A$42,"<="&E3,$A$3:$A$42,$A$3:$A$42)),0)))

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).