Apr 28 2022 08:54 AM
I have a tracker that I update one day a month with data of patients that we see. On the same workbook I have another section that gives the averages of patients seen on certain dates. The formula I'm currently using includes the data of the whole month, even days that have not occurred yet and it's including the 0 when calculating the average. I was wondering if there's a formula that can only calculate the average visits from the start of the month to the present day TODAY()?
Apr 28 2022 09:13 AM
SolutionChange the formula in your screenshot to
=IFERROR(AVERAGEIFS(F$5:F$34, $B$5:$B$34, "<="&TODAY(), $C$5:$C$34, $N14), 0)
Apr 28 2022 10:34 AM
Apr 28 2022 09:13 AM
SolutionChange the formula in your screenshot to
=IFERROR(AVERAGEIFS(F$5:F$34, $B$5:$B$34, "<="&TODAY(), $C$5:$C$34, $N14), 0)