Thread: Count on dates
View Single Post
  #5   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


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.