Vba to create report

Hello,

Attached is a spreadsheet of data readings from a piece of equipment. I want a way to view min, max, and average based on a date range. Values in column B indicate a specific data reading. Values in column C are the dates the values were recorded. Values in column D is the recorded measurement. So, for example, I'd like to look at a reading in column B, date range in column C, and the min, max, and average of the values in D based on the first two requirements.

I know this is possible with AGGREGATE and auto filter, but can i do it with VBA and generate a report for all values in B between a certain date range, possibly outputted to a pdf or another spreadsheet/workbook?

Thanks