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.
Bookmarks