I tested the formula before I posted it and it worked for me at that time.
Do you have *real* dates in Column B or are they text values (you can check
by looking at Format/Cells)?

--
Rick (MVP - Excel)


"Vijay DSK" wrote in message
...
Rick,
When i tried that i am getting a "#value" error Help me out

"Rick Rothstein" wrote:

Give this a try for April 2009...

=SUMPRODUCT((MONTH(B1:B70000)=4)*(YEAR(B1:B70000)= 2009))

Change the 4 (month = April) and 2009 (year of interest) to suit your
conditions. I used 70000 rows to make sure I covered the 60000 rows
(records) you mentioned in your first posting... the number used (same in
both ranges) has to be larger than the number of actual records being
examined.

--
Rick (MVP - Excel)


"Vijay DSK" wrote in message
...
Dear friends,
thanks for your speedy help and Mike my apologies if i didnot ask the
question properly.
I want to find the number of cells in column2 basing on the month
April.
example i found 16 cells in the example which i pasted in this post.
Like
wise on every month.
hope i am clear in asking this time.

Thanks once again





"Vijay DSK" wrote:


Dear ashish
i want to check up on "To" column ( ie., column 2)

"Ashish Mathur" wrote:

Hi,

On what column would you like to check for Apr-09, Jun-09 etc.
Please
clarify.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Vijay DSK" wrote in message
...
Hi all,
Thanks for the previous help.
Now i am struck with another problem hope you guys can help me
out.

My issue is i have two columns like
Col1 Col2
Date date
from to
15/04/2008 14/03/2009
.... and so on (Sixty thousand records with different dates)

now i want to filter the data on Month wise for instance...
i want to count all the values under the month Apr-09, May-09,
June-09
etc.
Hope i am clear in asking the question.
A speedy help will be greatly appreciated.