datewise average and maximum values

[sachinhingwe3]

Hi team
I have an excel sheet attached which has the readings of the license usage.
It has 26 readings every day.

Excel has below columns and this is a contentiously growing excel sheet as it collects the readings daily.
Date , Time, Day & used licenses
It collects 26 readings every day.

But now I want to make the readings as below

Date,Day,Average License in use, Maximum Licenses in use

Pls suggest the way how can i work out it.

Many thanks for your help.

Regards
Sachin