title: Running Sum of Last 30 days by day
body: <p>I am looking for a query that sums all the leads from the last 30 days (including that day) by each day.</p>
  
  <p>For example...</p>
  
  <p>if date=8/1/18 then I want a sum of the leads from  7/2/18 to 8/1/18<br>
  if date=3/17/20 then I want a sum of the leads from  2/17/20 to 3/17/20</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1Kwe7CFbUV6P3Byt4xQg23-DF1FLJS94mA7aYUQuuArY/edit?usp=sharing" rel="nofollow noreferrer">Here is a link to a sheet where the concept is layed out</a></p>
  
  <p>Thank you in advance for any assistance!</p>