Automating the gathering of one specific word in a range and then counting the number of occurrences of that word.
So the is a column in a excel file that mentions the date of something being completed. If the task is completed, there will be a date in the column. I was looking to count the number of text occurrences based off the dates inputted into the columns
So if I want to know how many April dates are in the column I would like to have a message box appear with the number of April’s found in the column.