title: SUMIFS with Date Range...but X days before and X days after
body: <p>I am trying to create a SUMIFS function that is adding totals based on several parameters.  The final parameter is to use a date in a column and then look for any dates 7 days prior and 7 days after.</p>
  
  <p>I have a list of invoices I am trying to sum up based on travel...conceivably people who are traveling will travel in a short duration.  I cant add all invoices up because someone might travel at the beginning of the month and at the end, creating 2 trips.</p>
  
  <p>Lets say the date is in Column I and my criteria cell is I10, I tried to enter the Criteria Range as "(I10-7)=>I10&lt;=(I10+7)"</p>
  
  <p>But this is clearly wrong.  Any help is appreciated!</p>