Count color cells in a spacific date range using VBA

Hello,

I've recently learned about VBA code and I think it can solve a problem I currently have, but I don't have any experience with it.

In the attached document (all sensitive information has been removed), I need to enter formulas in the highlighted cells that can be refreshed everyday to show how many parts have been manufactured and sold that day and in the current month.

Using "Part 1" in the manufactured section:
- For Daily Actual, I need to count all of the "blue" cells in the F Column of the "Part 1" sheet that has today's current date.
- For MTD Actuals, I need to count all of the "blue" cells in the F Column of the "Part 1" sheet that has a date range for the current month we are in. Our current manufacturing month runs 2/25/24-3/30/24.

Then I will need to repeat this for each part # and somehow make the dates adjustable for when the month's roll over. That's a bridge I'll cross when I get to it.

I've used countif/ifs functions but it's my understanding that a simple formula doesn't exist to count cells with a specific color. I've found code that creates a count_color formula for me and it works, I just don't know how to add additional criteria like a date/date range.

Any help you can provide would be absolutely appreciated!

Tahnks1
Jessie

Hi and welcome

Could we see what the current code you have?

Also may be beneficial if we could see an example or two of your expected outcomes.

BSB

The color_count code I found is as follows:

Please Login or Register  to view this content.

The outcome for Part 1 Daily Actual in the manufacturing section should return a 1, as there was one part completed with today's date (highlight blue in the F column of second sheet), and the MTD Actual should return a 9, as there were 9 parts completed (highlighted blue) between the dates of 2/25/2023 and 3/30/2024.