calculate days count between 2 dates

[Wadda7AboUdai]

Hello Everyone 

I want to calculate days starts with item purchese date to item transfer date , items can be more than ones in the table it means can be purchesd more than ones and for all branches , I want to calculate the days  for each branch and sorted by dates if there are more than one purches order 

Here is the source table 

item	transaction number	type	date	decs	branch
A	01	3	01-01-2024	purchase order	A
A	01	22	10-01-2024	Transfer order	A
A	02	3	07-01-2024	purchase order	A
A	02	22	14-01-2024	transfer	A
B	03	3	01-01-2024	purchase	A
B	04	3	01-01-2024	purchase	B
B	03	22	13-01-2024	transfer	B

I want to Get the result like this 

item	transaction number	branch	Days Count
A	01	A	9
A	02	A	7
B	04	B	12

[lbendlin]

so the last row should read 04?

BTW, where I come from Jan 1 to Jan 13 is 13 days, not 12 days.