Count the number of times a month appears within in a range!

Do you know how to count the number of times a specific month appears in a range of dates?

This scenario is made really easy with the use of the SUMPRODUCT function in excel! Not sure how to use SUMPRODUCT? Watch this video and I'll show you how!

This video is in response to a recent question I received, so if you have a question or subject you would like me to cover, just drop a comment below this video and I will do my best! 😃

#excel #vba #tutorial #msexcel #macros #visualbasic

[EssentialExcel]

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!

[jonathanjackson]

Worked well apart from January, any advice?

[Keytliin]

hI! when I put one (1) for January, it's not working :( help

[caluml]

Great video. I do have one question though. I am currently counting the number of times a date comes up in a dataset. However, the dataset has got “TBC” next to some actions, so not every cell is populated with a date. This then messes up the formula and instead of giving an answer just provides “#Value!”. Could you recommend a way to fix this issue. Thanks!

[martaymay]

Really good and a big help. Similarly, my range covers more than one year eg I might have 3 Februarys in 2022 and 1 in 2023. How do I show how many in each year because this way will show 4 overall?

[santanamayapadav.i.p.]

Im struggle with the december, am I put the wrong number? I put 12? please help

[GAmontfort]

For December is counting all the occurrences of 12 but all so the empty cells

[accountingchannel]

blank cells is counted, what formula for exception?

[DJEK]

Exactly what I was looking for. Thanks much!

[Lol-vtln]

I’m doing this but changing the month value to an entire column (g:g) and getting a value error. Would you know why this is the case? Thanks for the video!

[braddas]

My range of approx 4, 000 cells includes blank cells; as the range gets completed as the year progresses.
Currently there's data for Apr to Jun, the rest show 0 except Jan; which shows approx 3, 200 as the blank cells in my range returns as a 1, which is Jan.
Can you help with this please to ignore the blank cells.
Many thanks.

[StevieC]

What would the formula be if I wanted to count the number of occurrences of a person's name in a month?

[thtgrldiana]

Hi, Thank you for your knowledge sharing! I am managing help desk tickets. I want to perform a calculate function that tells me how many tickets were created on a specific day. I want to show this calculation for each calendar day where an incident was created. I have several columns: I have an INC number column, Date created, Date closed. the date columns are formatted as 01/01/2021 (mm/dd/yyyy). I also want to perform this calculation/function in a seperate worksheet. It seems counting date occurrences are not as straight forward as other sum/count functions. The basic Count/countIf functions are not working and I couldn't figure out how to implement your solution either... please help. 🙂

[StevieC]

How would I count the number of occurrences in a month based on a name in another column? Thanks

[AliceBaker-cm]

I have used this formula with success until I needed to count the times December appeared. The formula then returned the wrong count, I think this is because there are clank cells and all blank cells equal December... so how can I ignore the blank cells within this formula?