I have a spreadsheet for daily sales. Details of each sale (including Date,
Order No, Product, Quantity, Unit Price, Discount, Total Price, etc) are
recorded on each row. The Date format is "dd/mm/yyyy (ddd)".

I would like to create a PivotTable to count the total sales of each product
for each month. However, I am having problem to do the count by month.
Currently, I have to add another Month column (and then hide the Month
column) in front of my Date column to indicate the month, and in order to do
the count by month in my PivotTable.

Is there a smarter way of doing the above?