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.

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.