Issue with pre formatted date in pivot table (Cannot group that selection)

Originally Posted by rorya

Instead of using a TEXT formula (which will naturally return text, not a date), assign a date value to the cells and use their numberformat property to format the date.

Thanks, that was it, the date wasn't a number, but a text obviously