Inventory Count from Count in a Date Range

I have two tables, Date and Inventory. Inventory is a distinct look at inventory with a New date and Sold Date attached. Is there a way to take the Date from the Date Table and count how many times i...