I am looking to count the number of times the month and years recur in a column. So, if it is FEB 19 and it shows up 19 times I would like to count that number of times. Is there any possible way for me to make this happen, Thank you in advance
Formatting cells with the date serial value0s 43497, 43498, 43499 (which are the dates 2/01/2019, 2/02/2019 and 2/03/2019... up to 43524 which is 2/28/2019 if formatted using your MMM YY would All show Feb 19, so you need to test if a cell value is dated 2/01/2019 or greater and 2/28/2019 or lesser.
Ah ok I see what you are getting at. With your new posting I feel my first post was not as detailed as it should have been. I guess i thought it was a easy fix for what i was looking to do. I have a condition formatting that shows upcoming record follow ups. The game plan is to count all those for the next month automatically. It be a bonus if I had a separate formula for 2 months out but I be more than happy with the original question. I was trying to use the Today function plus 1 but didnt work out.
I attempted use this modified formula but it would appear no matter what number I placed on the back end it, it ends up being the number that appears. I was attempting to get this to auto count for the upcoming month but the month and year. I have months all the way out to 2025 but only need to count for one year and the upcoming month.