Count items between two dates (stored as status)

Hello,   I have list of facilities which has been active during only some periods - the format (sample) of table is:   FacilityID DateFrom Status 123 2017-10-01 0 123 2017-01-01  1...