There is probably a simple formula for this that I can't work out, but here it goes.
Lets say I have a worksheet with (as an example) Column A containing a list of dates spanning 3 years.(generally weekly dates)
Column B contains dollar amounts for each date listed.
What I want to do is have column C providing me with a calculation for the TOTAL dollar amount for each financial year. Of course, if it was per calandar year it would be simple to use the year function, but how do I do it based on financial year??
I look forward to being proven a simpleton on this... in other words, I would love an answer.
Raa
Lets say I have a worksheet with (as an example) Column A containing a list of dates spanning 3 years.(generally weekly dates)
Column B contains dollar amounts for each date listed.
What I want to do is have column C providing me with a calculation for the TOTAL dollar amount for each financial year. Of course, if it was per calandar year it would be simple to use the year function, but how do I do it based on financial year??
I look forward to being proven a simpleton on this... in other words, I would love an answer.
Raa