So 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. so... 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. like.... 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.