They are formatted as text but when I change them to dd/mm/yy format I still get the same. The pivot table refuses to group them into quarters. What I need is, alongside each date a number corresponding to the quarter of the tax year eg. 01.04.06 would give me 1 etc. Any help appreciated.
Thanks. Inky thats a very clever and simple way of converting to dates. VoG, that formula is not working for me - not sure if it's a formatting problem but I have formatted the cell to date. Anyway, thanks both. I actually ended up using a vlookup table which was a a long way of doing it but it worked. Will use your methods next time round. Thanks.
This thread is now locked and can not be replied to.