Average Change per Week

[JTL9161]

I have these dates with numbers
A B C D E F

8/25/2024	9/1/2024	9/8/2024	9/15/2024	9/22/2024	9/29/2024
74,400	68,400	64,100	59,200	55,500	51,500

Each week a new number is added. How do I calculate the average change per week in a formula in Column G

Thanks
James

 

[Joe4]

Take the last number and subtract the first number and divide by the number of weeks, i.e.

=(F2-A2)/5

or

=(F2-A2)/(COUNT(A2:F2)-1)

 

[JTL9161]

Thank you.

 

[Joe4]

You are welcome.