Let’s say you a list of payment dates from customers.

Data

Data

You want to check, how many payments are you going to receive in

  • Tomorrow
  • This week
  • Next week
  • This month
  • Next month
  • Next quarter, etc.

There is an awesome feature within Filter. Steps: –

  1. Click on the Filter in the Data tab, so you will the filter options in all the columns.
  2. Go to the Date of Payment column filter option, and go to Date Filters.
  3. Click on whichever you need.
Date Filters

Date Filters

I’m writing this post on 7th April 2015, so TODAY would mean 7th April 2015, and all other dates will work on the basis of this date.

Examples: –

  1. TODAY

    Today

    Today

  2. NEXT WEEK

    Next Week

    Next Week

  3. NEXT MONTH

    Next Month

    Next Month