Track status change over time between dates

Hi all,   I'm trying to calculate the status of certain records on a day-by-day basis between 2 dates (Opened and Closed). I also have a 3rd date column which helps us determining the actual status...