datewise average and maximum values

Welcome to the board.

Pivot table?

Row\Col	H	I
1	Max of Used-Licenses
2	Date	Total
3	Tue 07 Apr 2015	49
4	Wed 08 Apr 2015	54
5	Thu 09 Apr 2015	61
6	Fri 10 Apr 2015	57
7	Sat 11 Apr 2015	24
8	Sun 12 Apr 2015	23
9	Mon 13 Apr 2015	62
10	Tue 14 Apr 2015	62
11	Wed 15 Apr 2015	58
12	Thu 16 Apr 2015	59
13	Fri 17 Apr 2015	58
14	Sat 18 Apr 2015	26
15	Sun 19 Apr 2015	26
16	Mon 20 Apr 2015	63
17	Tue 21 Apr 2015	58
18	Wed 22 Apr 2015	59
19	Thu 23 Apr 2015	64
20	Fri 24 Apr 2015	60
21	Sat 25 Apr 2015	27
22	Sun 26 Apr 2015	26
23	Mon 27 Apr 2015	57

Another solution without Pivot Table

For average

Please Login or Register  to view this content.

For Maximum

Please Login or Register  to view this content.

This is an arrey function (enter with ctrl + shift + enter)

Maybe this workbook will help you with the pivot table that shg showed you. You should be able to see how it was done. On the Design Tab, Subtotals and Grand Totals were turned off and the Layout was chosen to be Show in Tabular Form.