COUNTIF with Date formula

[Jay__Oh]

I need to put together a countif function that counts all the occurances of a particular date, this date is displayed in a given cell, for the purposes of this example I will say D3. D3 contains its own formula to determine which date is displayed. I currently have:

=COUNTIF(Active!$B$3:$B$65536,D3)

but this results in 0 everytime. I have a hunch that its due to the formula within cell D3, I know this because when I replace the formula with the resulting date it changes to the number I'm looking for.

Any advice?

[Carim]

Hi,

=COUNTIF(Active!$B$3:$B$65536,"="&D3)

HTH
Carim

[Jay__Oh]

Carim,

Thanks, but I also tried that variation. Still getting zero results when I'm starring at 3 occurances on the sheet.

[Carim]

In this case, you have a date format problem somewhere ...or in D3

Do you mind uploading a zipped copy of your worksheet ...?

Carim

[Jay__Oh]

Attached.

I'm trying to list the number of occurances of D3 in the range & results in D6 & the same for E3&E6 etc....

[Carim]

Hi,

In cell A1, replace now() by today() ...

as I told you the date formats can be tricky ... now() shows both today() and the exact time ... which prevents any matches ...


HTH
Carim