Hi,

I have an excel sheet like the one below. Now I want to count number
of images in day basis. That is how many on 1-feb-08, how many on 2-
feb-08,
Date Shift Image No. HC Manip Min Worked
1-Feb-08 III 28135 1 0 15.00
1-Feb-08 III 28169 1 0 15.00
2-Feb-08 III 0 0 15.00
2-Feb-08 III 28197 1 0 15.00
2-Feb-08 III 28244 1 0 15.00
3-Feb-08 III 28267 1 0 15.00
3-Feb-08 III 28270 0 1 15.00
4-Feb-08 III 28271 1 0 15.00

Can someone please help me with this.

=COUNTIF(A:A,--"2008-02-01")

or if the date is in a cell say M1

=COUNTIF(A:A,M1)


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Harsha" <(E-Mail Removed)> wrote in message
news:f1eaad46-e345-4a83-bee5-(E-Mail Removed)...
> Hi,
>
> I have an excel sheet like the one below. Now I want to count number
> of images in day basis. That is how many on 1-feb-08, how many on 2-
> feb-08,
> Date Shift Image No. HC Manip Min Worked
> 1-Feb-08 III 28135 1 0 15.00
> 1-Feb-08 III 28169 1 0 15.00
> 2-Feb-08 III 0 0 15.00
> 2-Feb-08 III 28197 1 0 15.00
> 2-Feb-08 III 28244 1 0 15.00
> 3-Feb-08 III 28267 1 0 15.00
> 3-Feb-08 III 28270 0 1 15.00
> 4-Feb-08 III 28271 1 0 15.00
>
> Can someone please help me with this.