Macro coding to count

[Saky]

Friends,

I need ur help, I need a macro coding for the below case:

In worksheet2 i have named the column A as Completed date. In which i have entered many dates like 22 Nov 2010,23 NOV 2010.....01 DEC 2010,02 Dec 2010...etc

In worksheet1 i have created a table with two columns say month and Completed.
Now i need a macro coding that should work in a way that it should count how many dates has been entered in worksheet2 for the month of november and how many in the month of december.

The final result in worksheet1 should be:

For ex:

Month Completed
Nov 5
Dec 9

[royUK]

why would you need a macro? What's wrong with a PivotTable or COUNTIF

[Saky]

Yeah tat's fine...But can you help me to do countif.

[Saky]

Friends can any one help me on this..Kindly help me how to use the countif function for the above scenario.

[royUK]

Read COUNTIF

[Saky]

Roy, Thanks for the article..Now i understood the countif function....but in my excel i am entering dates...So how do i need to mention the criteria in Countif function. Can you help me...

[royUK]

I think a pivottable would be best, you need to attach an example workbook

[Saky]

I think a pivottable would be best, you need to attach an example workbook

Roy, thanks for your quick reply and assistnace.. I have attached my excel.

If you go to sheet2 i have entered the dates in the columns like start date ,target date and completion date.

i need a macro or countif function which should read the status first,

if the status is "WIP" then it should read the target date and if the target date falls on november month then it should reflect the count as 1 against november month under WIP column in worksheet1.

And if the status is "overdue" then as said above it should read the target date and should show the count under Overdue column in sheet1 in monthly basis.

If the status is "completed" then it should read the completion date and if the completion date falls on november month then it should reflect the count as 1 against november month under Completed column in worksheet1.

If the status is "Not started" then it should read the Start day column and should check the month it falls and according to it it should reflect the count in sheet1 under Not started column.

Kindly help me...

[Saky]

Friends, can any one help me to solve the above case using macros.

Thanks for your help in advance...