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