Hello!
I'm trying to use the AVERAGEIF function in my app; my idea is to use that for calculate the average of a column of data in my table, but using conditions and functions. I wanna make it calculate the average of values on today's date, ignoring past values in the column. For that, I created this formula:
For example, in column "Days", I have the serial date of yesterday (44402.5), and the now serial date (44403.2). My average should only calculate for today, because DATE function returns 44403, but it isn't work. I tried to use the number itself, and It works; but to make it useful, this value must change every day. There's a way to use this function or a cell reference in AVERAGEIF?
Thanks!
Yes, you can use AVERAGEIF to calculate an average of dates Happy to show you how:
I created an example with yesterday's and tomorrow's dates. To calculate the average, I used =AVERAGEIF(A2:A3, ">0"), which is the range of the dates in the table and will give me the serial value of that date: