Forum Discussion
Group data by date range
I have a power querry with a list of clients invocies, when they where created and when is the due date for the client to pay. I want to make a dynamic table or a slicer that groups the invoices in these ranges:
- payment has been delayed between 1 to 5 days
- payment has been delayed between 6 to 29 days
- payment has been delayed by 30 days or more
I've attached an example excel.
I appreciate your help 🙂
1 Reply
Here's a starter for you. I'll let you refine it further. On Sheet1 there's a single cell A2 into which you can enter a number of days. The following FILTER formula, then, in cell C2, will list all those that exceed that number of days.
=FILTER(Hoja1!A2:F27,(ISBLANK(Hoja1!G2:G27)*(TODAY()-Hoja1!F2:F27)>Sheet1!A2))
The FILTER function is only available in the newest version of Excel, so if it doesn't work for you, you'll need to upgrade.
