Hi Group,

I have hundreds of rows of data.
I would like to group the data by UK financial year (01 Apil - 31 Mar)
to obtain totals by releavnt years.

Can someone suggest a way forward? I have tried pivot tables but Excel
says it cannot group on that data. Ideally, I would like to end up
with something like the following:

Year Total Payments
01/04/2002 - 31/03/2003 £79,557.25
01/04/2003 - 31/03/2004 £244,728.69
01/04/2004 - 31/03/2005 £450,063.19
01/04/2005 - 31/03/2006 £5,000.00

Many thanks
Tony