Hi,
I am trying to do an AVERAGEIFS formula but the provided answer is not correct. Current formula I have is =AVERAGEIFS(D:D, B:B, ">="&A2, C:C, "<="&A2)
I have a long list of sequential dates in Column A, column B is the date a device was sent (or today if not sent), column C the date it was...