Date format in pivot table

[spyrospoulis]

I make a pivot table and the dates cannot be format as <date-month-year>, in fact the date cannot be in a form that has the year in it. Although the table that pivot table is built is correct formated, see below. How can I have the dates without before dates and after dates and the year appeared in the filter. The data base table is correct formated. How can amend the pivot table?

 

[Alex Blakenburg]

I am not sure I fully understand where you are at but try this:-
Right click on any of the dates in the Pivot table and select ungroup.

Does that do what you want ?

 

[spyrospoulis]

mc Incomes.xlsx
	A	B	C	D
3	Row Labels	Sum of Καθαρή αξία
4	15/6/2021	1645,27	1.645,27	0,00
5	16/6/2021	4493,28	4.526,74	-33,46
6	17/6/2021	4421,15	4.372,28	48,87
7	18/6/2021	6844,05	6.778,02	66,03
8	19/6/2021	10739,9	10.739,90	0,00
9	20/6/2021	11243,52	11.243,52	0,00
10	21/6/2021	8721,43	8.625,47	95,96
11	22/6/2021	4536,79	4.481,77	55,02
12	23/6/2021	6540,97	6.474,05	66,92
13	24/6/2021	6033,03	5.943,68	89,35
14	25/6/2021	7173,9	7.201,19	-27,29
15	26/6/2021	7997,81	8.003,09	-5,28
16	27/6/2021	2831,55	2.831,55	0,00
17	28/6/2021	3145,98	3.135,41	10,57
18	29/6/2021	5621,99	5.581,93	40,06
19	30/6/2021	5443,19	5.422,94	20,25
20	1/7/2021	10520,9	10.520,90	0,00
21	2/7/2021	15302,8	15.183,06	119,74
22	3/7/2021	17551,25	17.551,25	0,00
23	4/7/2021	20079,04	19.906,92	172,12
24	5/7/2021	10556,1	10.556,10	0,00
25	6/7/2021	14394,63	14.398,66	-4,03
26	7/7/2021	17702,36	17.692,95	9,41
27	8/7/2021	22408,7	22.380,08	28,62
28	9/7/2021	23909,84	24.096,71	-186,87
29	10/7/2021	30019,17	30.321,69	-302,52
30	11/7/2021	27343,23	27.500,70	-157,47
31	12/7/2021	30934,14	31.035,43	-101,29
32	16/6/2022	33,46		4,71
33	Grand Total	338189,43
34
Sheet10

Cell Formulas
Range	Formula
C4:C31	C4	='db-Opera -- pt'!C18
D4:D31	D4	=B4-C4
D32	D32	=SUM(D4:D31)

 

[spyrospoulis]

Yes it work, thank you.

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.