Let’s say you a list of payment dates from customers.
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: –
- Click on the Filter in the Data tab, so you will the filter options in all the columns.
- Go to the Date of Payment column filter option, and go to Date Filters.
- Click on whichever you need.
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: –
- TODAY
Today
- NEXT WEEK
Next Week
- NEXT MONTH
Next Month
