Count Number of Open Items in the Last Month by Day
I am trying to make a chart showing the number of open items each day in the last month. In the last month will be flexible so this will be a item that autopopulates the chart as the month goes on. I have a column for the formula =TODAY(-1), =TODAY(-2), etc. to populate the dates for the last 30 days. I have a "received" column to show when an item becomes 'open' and a "to client" column to show when an item is 'closed'. I am not sure what formulas to use to make this happen.