If your data has gaps in the date range, you can still use the AVERAGEIFS function to calculate averages by date in Excel. Simply exclude the criteria for the missing dates to avoid including those values in the calculation.