I'm using Excel 2016.
I am trying to figure out a way to create a formula that takes it's parameters from InputBox entries and then executes. Here's the function I'm trying to fix:
This formula works fine if you hardcode the dates. Example:
This formula is being executed from the "EmpRpt" sheet. I need this formula to count the number of entries on the "Employment" sheet with dates that range from "startDate" to "endDate" where the column labeled "Industry" is the value entered for "industry". I've tried getting the ">=" and "<=" operators into the formula, but nothing seems to be working.
Am I going about this the wrong way?
Bookmarks