Summary To summarize granular weather station data by day, you can use the GROUPBY function together with a few helper functions. In the worksheet shown, the source data is in an Excel Table named data on the data sheet, with one reading every 15 minutes for all of 2024.