I am using the following formula to calculate an average of data for a
rolling 365 day period. Column A is the date, column B is Data

=((SUMPRODUCT(--($A$1:$A3<$A3),--($A$1:$A3=$A3-365),($B$1:$B3))))/(SUMPRODUCT(--($A$1:$A3<$A3)*--($A$1:$A3=$A3-365)))

Is there a simpler way to accomplish this?

How can I calculate the standard deviation for the same period?