title: google sheet data filter for last a few days
body: <p>I have a google sheet to log what I do at work every day. 
  for example
  <a href="https://i.stack.imgur.com/NAduZ.png" rel="nofollow noreferrer">no filter</a></p>
  
  <p>I managed to figure out how to filter it by today.
  highlight colon -> data -> filter -> date is today
  for example:
  <a href="https://i.stack.imgur.com/FsO8D.png" rel="nofollow noreferrer">only today</a></p>
  
  <p>but I could not figure out how to filter it by the last x number of days
  for example:
  <a href="https://i.stack.imgur.com/IWHz7.png" rel="nofollow noreferrer">goal</a></p>
  
  <p>I guess I will need to make a custom filter, but I have a really hard time figuring out how to make custom filters in google sheet.</p>
  
  <p>Please help me. Thanks in advance.</p>