Calculating the number of days which fall in financial year

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

Are you taking the financial year as starting 1st April and ending 31st March the following year?

Pete

Hi Pete,

Yes, 1st April and ending 31st March.

Thanks for any help you can give
Dermot