Month count

[megaman777]

I'm hoping this is fairly simple to do.. But is there a way to count cells which contain dates for certain months? For example, where column A is Target Date, how do I count the number of cells which have a target date containing current month, next month, etc?

 

[vladimiratanasiu]

I'm hoping this is fairly simple to do.. But is there a way to count cells which contain dates for certain months? For example, where column A is Target Date, how do I count the number of cells which have a target date containing current month, next month, etc?

Did you try it? How to Count by Month in Excel - Statology

 

[megaman777]

Did you try it? How to Count by Month in Excel - Statology

I actually did have a look at that yea, but trouble is if I have data over several years then It wouldn't separate months from current year, for example.

I'm also trying to call specific cell entries where the date column is a specific month.