Hi All,

Anyone know how I could split the number of days beween two dates by financial year? ie

From To Amount Number of days which fall in 2011/12 financial year Number of days which fall in 2013/14 financial year
invoice A 01/09/2011 30/06/2012 £54,208.60
invoice B 01/04/2011 31/03/2012 £380,036.53
invoice c 28/02/2012 28/02/2012 £354.00
invoice d 01/02/2012 31/03/2012 £2,776.00
invoice e 01/02/2012 31/03/2012 £2,235.00
invoice f 01/04/2012 30/04/2012 £38,632.00
invoice g 01/04/2012 30/04/2012 £840,663.00
invoice h 01/04/2012 30/04/2012 £46,703.00
invoice I 01/01/2012 30/06/2012 £86.83
invoice J 01/04/2012 30/04/2012 £965,251.88
invoice K 01/04/2012 31/03/2013 £1,050.00

All help much appreciated