Date/Time - Count

[VegasL]

Hello,

I am trying to count # of occurances of date/time. Desired result is in Columns N & O.

See column F.

See attached spreadsheet for reference.

Thanks

[dhn46]

You use this Formulas

Please Login or Register  to view this content.

[Ace_XL]

In O2

=SUMPRODUCT(--(DATE(YEAR($F$2:$F$7),MONTH($F$2:$F$7),(DAY($F$2:$F$7)))=N2))

[Kevin UK]

Hi
In O2 and copy down.

Please Login or Register  to view this content.

[VegasL]

Thanks Kevin, Ace your formulas worked perfectly. Dhn46 got value error.

Kevin your's is an ingenious workaround. Ace you'rs makes sense as well, and what I was initially leaning toward.

[dhn46]

...Dhn46 got value error....

Hi VegasL
Can you show me the error from my Fomulas on your file?
Thank you!