Thread: Count on dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vijay DSK[_2_] Vijay DSK[_2_] is offline
external usenet poster
 
Posts: 33
Default Count on dates

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.