My name isXXXXX am working in the UK, I would prefer the date first then the month.
I used the Pivot Table Wizard to set up the table. Where do I enter the formula you provided? This is the first Pivot Table I have set up.
In my data sheet, the dates are in row E. The formula is input into E1 where the heading currently says "Date"?
Sorry for being thick.
File ID # XXXXX
A lot of the dates are showing as #VALUE! - will this affect the Pivot Table before I start with the Pivot Table Wizard?
ID Code 6 9 9 6 2 2 6 5 1
Password XXXXX 4 6 2
The numbers in the ID are in 3 batches of 3 numbers separated by one space
Using the column "Correct Date" that you originally added, it appears correctly in the Pivot Table, and I will now be able to highlight July as a Block to create a graph for Q3, which was the basis of my original question. On that basis, I am happy you have resolved my problem. Thanks.