I would like help allocating a Dollar value over different tax years.

To explain, my (Australian) tax years are 01/07 (1st July) - 30/06 (30th
June) etc.

If I receive an income contract payment that starts and finishes in the
same tax year, say received 08/08/2010 (8th August 2010) and finishes
12/11/2010 (12th November 2010), ALLOCATE 100% to the tax year ended
30/06/2011 (as all the income should be apportioned to the one tax year.

If I receive an income contract payment that starts in one tax year and
finishes in the next tax year, say received 08/08/2010 (8th August 2010)
and finishes 12/11/2011 (12th November 2011), ALLOCATE some to the tax
year ended 30/07/2011 and the balance to the next tax year ending June 2012.

In other words, look up the start date and then the end date, and if the
end date is in the same tax year as the start date, 100% goes to this year.
Otherwise, allocate only some to the current tax year and in the next
cell, repeat... if the start date was in the previous tax year, only
calculate what is due to the current tax year


My variable a

c9 = start date
D10 = finish date
AA9 = income received
AE3 = 01/07/2010 (start date of a tax year)
AE4 = 30/06/2011 (end of that tax year)
AF3 = 01/07/2011 (start of next tax year)
AF4 = 30/06/2012 (end of next tax year)

AE10 = where I want to return the $$$ amount to be credited for the
2010-2011 tax year.
AF10 = amount (if any) to be credited for the 2011-2012 tax year.



I would prefer a IF (nested or not) statement, or SUMIF etc rather than
VBA please.