I have this formula that returns the average of data in Column D, if the date in Column A is within 2 dates. It works fine if I specify what Cell has the initial date to compare to, but as data is added, I won't always know which cell in Column A that will be. Here's the formula I have.
=ROUND(AVERAGEIFS(D:D,$A:$A,">="&$A$3,$A:$A,"<="&$A$3+(DAY(EOMONTH($A$3,0)-1))),2)
So, starting in A3 I have dates that start with "1/1/2018". So this formula gives me the average of all data that was entered in the month of January. Lets say I want to see the Average of all data that was entered in the month of February, but I don't know what cell is contains "2/1/2018". How would I change the "A3" reference to find where the next month begins? Thanks.
=ROUND(AVERAGEIFS(D:D,$A:$A,">="&$A$3,$A:$A,"<="&$A$3+(DAY(EOMONTH($A$3,0)-1))),2)
So, starting in A3 I have dates that start with "1/1/2018". So this formula gives me the average of all data that was entered in the month of January. Lets say I want to see the Average of all data that was entered in the month of February, but I don't know what cell is contains "2/1/2018". How would I change the "A3" reference to find where the next month begins? Thanks.