Financial year calculation

Raa · May 1st, 2002, 06:34 AM

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

NateO · May 1st, 2002, 07:44 AM

This would all depend on the date ranges you have and how the business entity in question defines their fiscal year. Please let us know what these variables are.

nisht · May 1st, 2002, 08:39 AM

YOur problem can be solve by using pivotal table and then grouping on year.
I advise you to use pivotal table and take on line wizard help in forming pivotal table.

nishith desai
http://www.pexcel.com

May 1st, 2002, 07:44 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	This would all depend on the date ranges you have and how the business entity in question defines their fiscal year. Please let us know what these variables are. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 06:34 AM	#1
Raa New Member Join Date: Apr 2002 Posts: 1	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

May 1st, 2002, 08:39 AM	#3
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	YOur problem can be solve by using pivotal table and then grouping on year. I advise you to use pivotal table and take on line wizard help in forming pivotal table. nishith desai http://www.pexcel.com