Stock aging report in Excel

[MarkD018]

Hi, I am trying to create a stock aging report, below is example of data from a product and further below how it should look, can anyone assist how best to do this please?

product	date	month	qty movement	balance	range
102022	15/11/2018	Nov-18​	18​	18​	>365 Days
102022	29/11/2019	Nov-19​	14​	32​	181 - 365 Days
102022	30/11/2019	Nov-19​	-2​	30​	181 - 365 Days
102022	28/02/2020​	Feb-20​	-15​	15​	181 - 365 Days
102022	31/07/2020​	Jul-20​	20​	35​	61-90 Days
102022	29/08/2020​	Aug-20​	-2​	33​	31-60 Days
102022	15/09/2020​	Sep-20​	5​	38​	31-60 Days
102022	30/09/2020	Sep-20​	-2​	36​	0-30 Days

HOW SHOULD LOOK
>365 Days	181 - 365 Days	31-60 Days	61-90 Days	0-30 Days
0​	11​	5​	20​

 

[McGuilliam]

Could you explain how you get to the numbers in the "how should look"? This might make it easier to help.