I have to count the entry which contains "January".

G

gaurav

I have a data file which contains data date wise, now i want to count the no
of entries which have done in January. The data are not in seriol order like
and the entries could be increase. I have tried my best to get the answer but
not suceed yet.Could any one plz help me.?
 
B

Bernard Liengme

If the entries are real Excel dates: MONTH(A1) will give the month number
=SUMPRODUCT(--(MONTH(A1:A100)=1)) will count how many of the dates are
January dates
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Cannot sort a table containing text 5
If Formula and Dates 4
Embed the same Excel multiple times 0
Count partial dates 1
Countif Formulas 2
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top