Date range grouping of data

[varunicious]

I have a transactions data. I want to create a table having date range with account number and total amount of transactions.

For example:

Data:

Date    account Number     amount

11-July-19  XYZ                     40

11-July-19 ABC                      20

12-July-19 XYZ                        60

13July-19   XYZ                       20

13-July-19 ABC                    100

14-July-19 ABC                      50

16 July 2019 ABC                 40

and so on...

Desired Output for every 5 days interval (Can use a pivot table but unable to get the results):

Date                         Account Number          Amount

11-15 July 2019           ABC                           120

11-15 July 2019           XYZ                           120

12-16 July 2019          ABC                             140

[agni_gold]

PFA the required output

[Brett_Bleess]

Varun, did Agni's post and sample app help you get things sorted?  If so, please be sure to give them credit by using the Accept as Solution button on the post to mark it.  If you did something else, consider posting that and mark it.  If you are still working on things, if you can provide an update, others may be able to chime in with other ideas.

Regards,
Brett