Count cells with specific date

I am trying to count how many times an account has been worked on each day and have not been able to find a formula.

Ive tried

Please Login or Register  to view this content.

but get no results.

sample.JPG

I need to count how many cells contain
11/1/2015
11/2/2015
11/3/2015
11/4/2015
until current.

Thanks in advance for all the help

The only way I could get it to work was with a helper column. If you are open to that, then put this in cell D2 and drag down.
=ROUNDDOWN(B2,0)
Then do put this countif elsewhere...
=COUNTIF(D:D,42311) Where you use the numerical value of the date instead of the date.

With the dates in D2 and down and the original data in columns A:C and the account in E2 the dates in column F enter this is G2 and fill down to give the count each day for the account named.

Formula:

Please Login or Register  to view this content.

This treats each date and time as a serial number and uses only the left 5 digits.
If you want to use the Date function:

Formula:

Please Login or Register  to view this content.

To just get the transactions for each day modify the formula to

Formula:

Please Login or Register  to view this content.

You could also use a pivot table grouped on the date to give a count for each date.

	E	F
23	Row Labels	Count of Date
24	11/03/2015 12:22	13
25	12/03/2015 12:22	1
26	13/03/2015 12:22	3
27	Grand Total	17

If you want to see your data calculated, please upload a workbook with the data.

Here is a setup similar to yours giving totals per day, totals per Admin, etc using Pivot Tables, Countifs, Sumproduct, and Sumproduct with Account #. (Formulae have been provided previously in other messages.)