Count cell only if date matches current month & year

Hi,

I need to count entries on a spread sheet that only includes month-to-date data. I have entries that include multiple months and years, which I need for other cells on the same sheet.

How do I get excel to count only the current month's entries and input that number into a different cell? (e.g. only count January 2014's entries if it is currently January 2014). I tried to use the COUNTIF function with no luck, as I couldn't quiet get the coding right for counting the current month and year. I'd like to avoid using filters, as I want the count to be automated.

Help is much appreciated!

Thanks

there are to possible ways that come to mind

one is to find the datenumber of the first of the current month and also the datenumber of the current date and then countif the dates that meet the criteria (being greater or equal to the first datenumber and less or equal to the second number)

the other is to add a column containg the month() and year() and countif those date that match the current month and year

a sample in excel would do a lot

Try

=COUNTIFS(A1:A100,">="&EOMONTH(TODAY(),-1)+1,A1:A100,"<="&EOMONTH(TODAY(),0))

Originally Posted by Ace_XL

Try

=SUMPRODUCT(--(TEXT(A2:A10,"mmyyyy")=TEXT(TODAY(),"mmyyyy")))

This worked perfectly, thanks!

As a related question, how would I then only count that set of data IF another cell has a certain value? (ex: column A matches this month and year, AND column B is "Name")

Thanks again!

Originally Posted by Ace_XL

Try..

=SUMPRODUCT((TEXT(A2:A10,"mmyyyy")=TEXT(TODAY(),"mmyyyy"))*(B2:B10="Name"))

That worked! Thanks for the quick response

Along similar lines I have the formula below and want to add another part to check the date entered into the same row in column H is equal to the date I enter into cell A1.

Example cell A1 = Apr-14 so i want to only count if the date in column H is in the month and year of April 2014. The format of the date in H is dd/mm/yyyy

many thanks

any one have any ideas for this one?

On similar lines can we develop formula for a Quarter??