Date format in pivot table

spyrospoulis

New Member
Joined
Jul 17, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
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?


1626502788958.png


1626502724384.png
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
2,064
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jul 17, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
mc Incomes.xlsx
ABCD
3Row LabelsSum of Καθαρή αξία
415/6/20211645,271.645,270,00
516/6/20214493,284.526,74-33,46
617/6/20214421,154.372,2848,87
718/6/20216844,056.778,0266,03
819/6/202110739,910.739,900,00
920/6/202111243,5211.243,520,00
1021/6/20218721,438.625,4795,96
1122/6/20214536,794.481,7755,02
1223/6/20216540,976.474,0566,92
1324/6/20216033,035.943,6889,35
1425/6/20217173,97.201,19-27,29
1526/6/20217997,818.003,09-5,28
1627/6/20212831,552.831,550,00
1728/6/20213145,983.135,4110,57
1829/6/20215621,995.581,9340,06
1930/6/20215443,195.422,9420,25
201/7/202110520,910.520,900,00
212/7/202115302,815.183,06119,74
223/7/202117551,2517.551,250,00
234/7/202120079,0419.906,92172,12
245/7/202110556,110.556,100,00
256/7/202114394,6314.398,66-4,03
267/7/202117702,3617.692,959,41
278/7/202122408,722.380,0828,62
289/7/202123909,8424.096,71-186,87
2910/7/202130019,1730.321,69-302,52
3011/7/202127343,2327.500,70-157,47
3112/7/202130934,1431.035,43-101,29
3216/6/202233,464,71
33Grand Total338189,43
34
Sheet10
Cell Formulas
RangeFormula
C4:C31C4='db-Opera -- pt'!C18
D4:D31D4=B4-C4
D32D32=SUM(D4:D31)
 

Forum statistics

Threads
1,144,611
Messages
5,725,308
Members
422,608
Latest member
bswg5882

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top