Group data by date range

[AdrianRS87]

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 :)

[#2]

@AdrianRS87 

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.