Trying to Count Status Using Two Date Columns

I am trying to find the status of products based on whether or not the date selected is between two date columns. Here is an example of the data:   Item Manufactured Date In Service Date Out ...