GROUPBY a Range of Dates - Better Than a Pivot Table

If you have a list showing a date and an amount and you want to analyze the amount for each Range Of The Date, then you can do that with a Pivot Table. But if the source data changes you need to manually refresh the Pivot Table.

In this tutorial I will show you how to create this report by using the GROUPBY function to summarize your data for every bracket or range of the date and create multiple calculations while everything refreshes automatically if the source data changes.
here is the Function I create in Excel
=LET(
A,A2:A100,
B,B2:B100,
C,FLOOR(A,5),
D,-C-4,
E,{"Years","Total","Percent"},
VSTACK(E,DROP(GROUPBY(C&D,B,HSTACK(SUM,PERCENTOF)),1)))

You can watch my previous Tutorials:
GROUPBY The Basics and Beyond
   • GROUPBY Function  The Basics and Beyond  
Create a Slicer for the GROUPBY Function
   • A Slicer For The GROUPBY Function  

To book a corporate Training, visit:
www.OfficeInstructor.com