Hi,

I have two columns, A & B
Coulmn A = Date Column (formatted as: m/d/yy h:mm AM/PM;@)
Column B = Overall Score
Column A contains date from Jul 1 - Jul 7.

I just want to get the average of Column B, based on today's date.
I've used
=AverageIf("A:A","07/07/15","B:B")
but it returns nothing. Please help.

Thanks in advance.