Hi
I have a range of dates in the dd-mmm-yy format and I would like to change these to the mmm-yy format. I can do this so they appear correctly on screen but the content of the range remains dd-mmm-yy. The problem is that i want to create a pivot table with these and group them month by month, not day by day.
Can anyone help?
Many thanks
Mac
I have a range of dates in the dd-mmm-yy format and I would like to change these to the mmm-yy format. I can do this so they appear correctly on screen but the content of the range remains dd-mmm-yy. The problem is that i want to create a pivot table with these and group them month by month, not day by day.
Can anyone help?
Many thanks
Mac