How to start formula after x rows

[worldCurrencies]

I am trying to take the 3 month moving average of a column of data. The dates are in descending order. How would I make it so that the formula doesnt start until after it has 3 months of data?

 

[6StringJazzer]

You haven't given us very much information here.

Let's say your data starts in row 2 (headers in row 1), dates are in column A and the data you want to average is in column B. You did not say if the data is daily, or if there are gaps in the dates. I will have to assume there are gaps. You can put your moving average in column C starting row 2:

=IF(MIN(A:A)>DATE(YEAR(A81),MONTH(A81)-3,DAY(A81)),"",AVERAGEIFS(B:B,A:A,"<="&A81,A:A,">="&DATE(YEAR(A81),MONTH(A81)-3,DAY(A81))))

 

[worldCurrencies]

You haven't given us very much information here.

Let's say your data starts in row 2 (headers in row 1), dates are in column A and the data you want to average is in column B. You did not say if the data is daily, or if there are gaps in the dates. I will have to assume there are gaps. You can put your moving average in column C starting row 2:

=IF(MIN(A:A)>DATE(YEAR(A81),MONTH(A81)-3,DAY(A81)),"",AVERAGEIFS(B:B,A:A,"<="&A81,A:A,">="&DATE(YEAR(A81),MONTH(A81)-3,DAY(A81))))

My apologies, I will update the post. but the data is monthly data, not daily, therefore there are no gaps in dates. Column A has the monthly dates. Column b would have the value. Column C would have the 3-month moving average

 

[worldCurrencies]

I am trying to take the 3 month moving average of a column of data. The dates are in descending order. How would I make it so that the formula doesnt start until after it has 3 months of data?

The data and dates are monthly data, not daily, therefore there are no gaps in dates. Column A has the monthly dates. Column b would have the value. Column C would have the 3-month moving average

 

[6StringJazzer]

the data is monthly data, not daily, therefore there are no gaps in dates.

Actually it means that is a one-month gap between dates.

You can probably use a simpler formula. Are the dates the same day of the month each time?