I have a running spreadsheet, where I store the most recent balance(s) of my Allocated Pension account that I get from the internet.

I want to create a formula, in a new column that will:

• Compare the current balance, against the balance at the beginning of the current Financial Year (ignoring fees, withdrawals, etc.); and then
• Reset itself at the beginning of the NEW Financial Year, and start all over again; namely
• Repeat the process, cyclically.


What formula will do this?


Points of relevance are:

• A new line is created with each new entry.
• Dates are in column B.
• Amounts are in column D.
• The new column will be E.
• The Financial Year is from 1st July through to 30th June, inclusive.

Cheers,
Mick.