Forum Discussion
Can I create a formula to look at a date range, set criteria and return an average?
I have a spread sheet that contains rows with a fair bit of info. I'm looking to create a formula that will look for rows with a date within a certain range, then count the number of days between two...
I would second the request from Detlef_Lewin for a sample of the workbook (without any sensitive data). Post it on OneDrive or GoogleDrive with a link pasted here that grants access.
In the absence of that, if you have Excel 2021 or newer, something based this logic--rendered specific to the column references in your database--should work
=AVERAGE(FILTER(DataToBeAveraged,(Date>="StartDate")*(Date<="EndDate")))