Change formula to include rows less than today's date

[GREGRACH]

Hi All,

I have this formula which was provided to me and sorted one problem out which was great.

Now I need to adapt the formula so that instead of excluding rows with today's date, I want it to now only include rows with today's date. How do I adapt this formula so it is only including the rows containing TODAY() ?

=AVERAGEIF(E9:E80,"<>"&TODAY(),G9:G80)

Any help i could receive with this would be great! Thank you

 

[iyyi]

How about =AVERAGEIF(E9:E80,TODAY(),G9:G80)

 

[GREGRACH]

That is spot on! Thank you so much, I'm very very grateful!

How about =AVERAGEIF(E9:E80,TODAY(),G9:G80)