I have dates in column J and a corresponding number in column I. Rows of data get added daily. On another sheet I have the average of all the numbers in column I. How can I write a formula to average only the numbers in column I from the last 30 days?

It's more complicated and they are also sorted by other parameters, but I'm keeping the question simple.

Thanks,

Dan