Strange Excel Behavior with Use 1904 date system and Pivot table Grouping

[aliexcel]

Hi Everyone,

I have some payroll data so I have chosen to use excel "Use 1904 date system"

Say I have an Excel Table as below

Date	Amount
25/06/2017	100
26/06/2017	100
27/06/2017	100
28/06/2017	100
29/06/2017	100
30/06/2017	500
01/07/2017	100
02/07/2017	100
03/07/2017	100
04/07/2017	100
05/07/2017	100
06/07/2017	100
07/07/2017	100
08/07/2017	100

<tbody>
</tbody>

When I created a Pivot Table with Above data with Date going across the row area,Excel Automatically groups the date by Months.When I drill down say Month "June" it includes the amount 500 as "01/07" and Date 01/07 is missing under "July" .

Any Ideas ?

Using Excel 2016

Thanks

 

[mart37]

When you use de classic style and you make a new pivottable then the dates are correct.
(Analyze - Pivottable - Options - Layout)

 

[aliexcel]

When you use de classic style and you make a new pivottable then the dates are correct.
(Analyze - Pivottable - Options - Layout)

Thank you mart37, it does the trick.

could it be a bug ?