Originally Posted by
christopherw34
I'm trying to get a message box to appear at the end of my code to count lines that have "N" in a column and that are between today and 15 work days. Could someone help me here? The code keeps returning 0 and there are some.
Well, I saw a couple of things that looked off, one was that you were looking BEFORE today, and AFTER 16 working days, and workday is a worksheet function
Here is a suggested fix:
You'll have to take that logic and apply it to your sheet, but you get the idea. Also, I left your code in there for comparison, just commented it out.
Bookmarks