Let’s say you a list of payment dates from customers.
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.
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
- NEXT WEEK
- NEXT MONTH