I am creating a master tracker for all the technology in my school and it is pulling data from many sheets and placing it in to blocks and I am having trouble figuring out the following
School|Room|Model|Bulb Replaced|Bulb Replaced Date|Date Filter Cleaned|Bulb Model
each of those represents a column. Now what I want is a block to the side to count blocks that have data in them in the "Date Filter Cleaned" column that are within 6 months.
Then for the tricky part: I need a way to create something that will count between 2 dates, this way I can change them per school year, e.g., count between Sept 1 2013- June 1 2014. I could then just recreate and edit for each school year.
I have never done any sort of conditional counting based on dates so I do not know how.