Pivot Table

[Dummy Excel]

Hi All,
This is going to sound a little strange so bear with me....
Last week i was sitting with a colleague going through some data and he created a pivot table - this is fine i can do that.
Although he then did a few things to show dates in a weekly bucket ie 12/02/18-18/02/18. The raw data doesnt have that detail it just shows the individual days.
How did he do this?
i would ask him on Mon although hes on leave for a month

example of his pivot table:

Book1
	B	C	D
2	Count of Reference #
3	Row Labels	Total
4	15/01/2018 - 21/01/2018	4
5	22/01/2018 - 28/01/2018	7
6	29/01/2018 - 4/02/2018	21
7	5/02/2018 - 11/02/2018	47
8	12/02/2018 - 18/02/2018	63
9	19/02/2018 - 22/02/2018	64
10	Grand Total	206
Sheet1

your help is greatly appreciated
thanks
Sam

 

[M1chiel]

When you have data range in the row part of a pivot table, right-click on one of the dates and choose Group. Then choose Day and set the number of days to 7. This should give you the amount/sum by week of the variable you have in the colum data of the pivot table.