#### celestersue

##### New Member

- Joined
- Apr 16, 2013

- Messages
- 6

A1= 4/1/2013

D1= data

A2= 4/2/2013

D2=

A3= 4/1/2013

D3= data

So my formula could be something like this:

=CountA(D:D), AND(A:A, "4/1/2013")

and it would come up with the answer: 2

However that formula isn't correct and I can't wrap my head around how to fix it. How do I adjust it so that it will only count the number of cells that have data in them if the date is equal to the date in the formula?