Determine number of months between two dates based on Fiscal year.

C

chipgiii

Board Regular
Joined
Nov 24, 2008
Messages
136
Our fiscal year is from April 1 to March 31: example April 1, 2018, thru March 31, 2019, in FY 2019.

We have savings initiatives that may start prior to or during those months. Savings are recorded as the average of the savings divided by 12 months: 120k savings is 10k per month.

So if savings begin in November of 2018, the amount in FY 19 would be (using the 120K, 10K per month example), 4 months at 10k or 40k.

I have a start and end dates in each row for the savings and the amount. What I want to do is have a formula that calculates the number of months of savings for Fiscal years: So in the example just mentioned 4 months would be for FY19 and 8 months for FY 20.

I have a column for each FY year.

I would prefer a formula as opposed to VBA that will return a value for FYs and I can have any amount of FY year columns as I need.

Hope this makes sense.
 
Last edited:

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
Can you post some sample data so we can workout a solution?
 
Upvote 0
[TABLE="width: 3599"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="3"><col span="2"><col><col span="2"><col><col span="6"><col span="3"><col span="4"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FY 2017[/TD]
[TD]FY 2017[/TD]
[TD]FY 2017[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2018[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2019[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2020[/TD]
[TD]FY 2021[/TD]
[/TR]
[TR]
[TD]Savings Amount Local Currency[/TD]
[TD]Savings Amount USD[/TD]
[TD]FY19 Savings[/TD]
[TD]FY20 Savings[/TD]
[TD]Savings Start Date[/TD]
[TD]Savings End Date[/TD]
[TD="align: right"]01/01/17[/TD]
[TD="align: right"]2/1/2017[/TD]
[TD="align: right"]3/1/2017[/TD]
[TD="align: right"]4/1/2017[/TD]
[TD="align: right"]5/1/2017[/TD]
[TD="align: right"]6/1/2017[/TD]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD="align: right"]9/1/2017[/TD]
[TD="align: right"]10/1/2017[/TD]
[TD="align: right"]11/1/2017[/TD]
[TD="align: right"]12/1/2017[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]2/1/2018[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]5/1/2018[/TD]
[TD="align: right"]6/1/2018[/TD]
[TD="align: right"]7/1/2018[/TD]
[TD="align: right"]8/1/2018[/TD]
[TD="align: right"]9/1/2018[/TD]
[TD="align: right"]10/1/2018[/TD]
[TD="align: right"]11/1/2018[/TD]
[TD="align: right"]12/1/2018[/TD]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]2/1/2019[/TD]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/1/2019[/TD]
[TD="align: right"]9/1/2019[/TD]
[TD="align: right"]10/1/2019[/TD]
[TD="align: right"]11/1/2019[/TD]
[TD="align: right"]12/1/2019[/TD]
[TD="align: right"]1/1/2020[/TD]
[TD="align: right"]2/1/2020[/TD]
[TD="align: right"]3/1/2020[/TD]
[TD="align: right"]4/1/2020[/TD]
[/TR]
[TR]
[TD="align: right"]4,535.86[/TD]
[TD="align: right"]$750.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]09/02/18[/TD]
[TD="align: right"]08/02/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD]62.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]50,721.21[/TD]
[TD="align: right"]$71,052.04[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]01/03/18[/TD]
[TD="align: right"]12/03/18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD]5921.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]17,701.00[/TD]
[TD="align: right"]$17,701.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]11/15/17[/TD]
[TD="align: right"]10/15/18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD]1475.08[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]31,052.50[/TD]
[TD="align: right"]$31,052.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/30/17[/TD]
[TD="align: right"]09/30/18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD]2587.71[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]26,291.32[/TD]
[TD="align: right"]$7,955.29[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD]662.94[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]122,214.93[/TD]
[TD="align: right"]$36,980.08[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD]3081.67[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]89,015.57[/TD]
[TD="align: right"]$26,934.54[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD]2244.55[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]80,341.04[/TD]
[TD="align: right"]$24,309.78[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD]2025.82[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]65,460.50[/TD]
[TD="align: right"]$19,807.19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD]1650.60[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]110,754.22[/TD]
[TD="align: right"]$33,512.27[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD]2792.69[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]59,964.70[/TD]
[TD="align: right"]$18,144.26[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD]1512.02[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]167,836.43[/TD]
[TD="align: right"]$50,784.34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD]4232.03[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]47,420.81[/TD]
[TD="align: right"]$14,348.70[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/01/18[/TD]
[TD="align: right"]09/01/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD]1195.73[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]34,071.81[/TD]
[TD="align: right"]$26,426.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/16/17[/TD]
[TD="align: right"]09/16/18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD]2202.17[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]8,878,904.71[/TD]
[TD="align: right"]$15,677.90[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]06/02/18[/TD]
[TD="align: right"]05/02/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD]1306.49[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]18,225,147.01[/TD]
[TD="align: right"]$32,181.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]06/02/18[/TD]
[TD="align: right"]05/02/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD]2681.75[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]33,745,489.88[/TD]
[TD="align: right"]$59,586.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]06/02/18[/TD]
[TD="align: right"]05/02/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD]4965.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]1,117,940.41[/TD]
[TD="align: right"]$1,974.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]01/10/17[/TD]
[TD="align: right"]12/10/17[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD]164.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]16,631.47[/TD]
[TD="align: right"]$2,750.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]11/24/17[/TD]
[TD="align: right"]10/24/18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD]229.17[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]43,015.78[/TD]
[TD="align: right"]$60,258.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]01/08/17[/TD]
[TD="align: right"]12/08/17[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD]5021.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]7,836.04[/TD]
[TD="align: right"]$10,977.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]01/08/17[/TD]
[TD="align: right"]12/08/17[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD]914.75[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10,041.16[/TD]
[TD="align: right"]$14,066.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10/11/17[/TD]
[TD="align: right"]09/11/18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD]1172.17[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5,319.34[/TD]
[TD="align: right"]$7,451.52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]06/02/18[/TD]
[TD="align: right"]05/02/19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD]620.96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
So the result needs to calculate each row under FY19 & FY20 Savings?
 
Upvote 0
Is this the result you're after? Also dates before FY19 do you want them blank or calculated?


Book1
ABCDEF
1201820192020
2Savings Amount Local CurrencySavings Amount USDFY19 SavingsFY20 SavingsSavings Start DateSavings End Date
34,535.86$750.0051702-09-1808-02-19
450,721.21$71,052.04132503-01-1812-03-18
517,701.00$17,701.0015-11-1715-10-18
631,052.50$31,052.5030-10-1730-09-18
726,291.32$7,955.2951701-10-1809-01-19
8122,214.93$36,980.0851701-10-1809-01-19
989,015.57$26,934.5451701-10-1809-01-19
1080,341.04$24,309.7851701-10-1809-01-19
1165,460.50$19,807.1951701-10-1809-01-19
12110,754.22$33,512.2751701-10-1809-01-19
1359,964.70$18,144.2651701-10-1809-01-19
14167,836.43$50,784.3451701-10-1809-01-19
1547,420.81$14,348.7051701-10-1809-01-19
1634,071.81$26,426.0016-10-1716-09-18
178,878,904.71$15,677.9082002-06-1805-02-19
1818,225,147.01$32,181.0082002-06-1805-02-19
1933,745,489.88$59,586.0082002-06-1805-02-19
201,117,940.41$1,974.0010-01-1712-10-17
2116,631.47$2,750.0024-11-1724-10-18
2243,015.78$60,258.0008-01-1712-08-17
237,836.04$10,977.0008-01-1712-08-17
2410,041.16$14,066.0011-10-1709-11-18
255,319.34$7,451.5282002-06-1805-02-19
Sheet1
Cell Formulas
RangeFormula
C3=IF(YEAR(E3)<$B$1,"",DATEDIF($E3,DATE((C$1),3,1),"m"))
D3=IF(YEAR(E3)<$B$1,"",DATEDIF($E3,DATE((D$1),3,1),"m"))
 
Upvote 0
RasGhul said:
Is this the result you're after? Also dates before FY19 do you want them blank or calculated?

ABCDEF
Savings Amount Local CurrencySavings Amount USDFY19 SavingsFY20 SavingsSavings Start DateSavings End Date

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]4,535.86[/TD]
[TD="align: right"]$750.00[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]02-09-18[/TD]
[TD="align: right"]08-02-19[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]50,721.21[/TD]
[TD="align: right"]$71,052.04[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]03-01-18[/TD]
[TD="align: right"]12-03-18[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]17,701.00[/TD]
[TD="align: right"]$17,701.00[/TD]

[TD="align: right"]15-11-17[/TD]
[TD="align: right"]15-10-18[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]31,052.50[/TD]
[TD="align: right"]$31,052.50[/TD]

[TD="align: right"]30-10-17[/TD]
[TD="align: right"]30-09-18[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]26,291.32[/TD]
[TD="align: right"]$7,955.29[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]122,214.93[/TD]
[TD="align: right"]$36,980.08[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]89,015.57[/TD]
[TD="align: right"]$26,934.54[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]80,341.04[/TD]
[TD="align: right"]$24,309.78[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]65,460.50[/TD]
[TD="align: right"]$19,807.19[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]110,754.22[/TD]
[TD="align: right"]$33,512.27[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]59,964.70[/TD]
[TD="align: right"]$18,144.26[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]167,836.43[/TD]
[TD="align: right"]$50,784.34[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]47,420.81[/TD]
[TD="align: right"]$14,348.70[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]34,071.81[/TD]
[TD="align: right"]$26,426.00[/TD]

[TD="align: right"]16-10-17[/TD]
[TD="align: right"]16-09-18[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]8,878,904.71[/TD]
[TD="align: right"]$15,677.90[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]18,225,147.01[/TD]
[TD="align: right"]$32,181.00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]33,745,489.88[/TD]
[TD="align: right"]$59,586.00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]1,117,940.41[/TD]
[TD="align: right"]$1,974.00[/TD]

[TD="align: right"]10-01-17[/TD]
[TD="align: right"]12-10-17[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]16,631.47[/TD]
[TD="align: right"]$2,750.00[/TD]

[TD="align: right"]24-11-17[/TD]
[TD="align: right"]24-10-18[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]43,015.78[/TD]
[TD="align: right"]$60,258.00[/TD]

[TD="align: right"]08-01-17[/TD]
[TD="align: right"]12-08-17[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]7,836.04[/TD]
[TD="align: right"]$10,977.00[/TD]

[TD="align: right"]08-01-17[/TD]
[TD="align: right"]12-08-17[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]10,041.16[/TD]
[TD="align: right"]$14,066.00[/TD]

[TD="align: right"]11-10-17[/TD]
[TD="align: right"]09-11-18[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]5,319.34[/TD]
[TD="align: right"]$7,451.52[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

</tbody>
Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C3[/TH]
[TD="align: left"]=IF(YEAR(E3)<$B$1,"",DATEDIF($E3,DATE((C$1),3,1),"m"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D3[/TH]
[TD="align: left"]=IF(YEAR(E3)<$B$1,"",DATEDIF($E3,DATE((D$1),3,1),"m"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...
I will look closely in a bit; the number of months should never exceed 12. I might not have been clear, but it is the number of months in a given FY that include the months within the start and end time period.
 
Upvote 0
Are you able to populate some of your sample rows so I can work on modifying the formula?
 
Upvote 0
RasGhul said:
Are you able to populate some of your sample rows so I can work on modifying the formula?
Click to expand...

Savings Amount Local CurrencyFY18 SavingsFY19 SavingsFY20 SavingsSavings Start DateSavings End Date

<thead>
[TH="align: center"]A[/TH]
[TH="align: center"]B[/TH]
[TH="align: center"]C[/TH]
[TH="align: center"]D[/TH]
[TH="align: center"]E[/TH]
[TH="align: center"]F[/TH]

</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]4,535.86[/TD]
[TD="align: right"]$750.00[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]02-09-18[/TD]
[TD="align: right"]08-02-19[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]50,721.21[/TD]
[TD="align: right"]$71,052.04[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]03-01-18[/TD]
[TD="align: right"]12-03-18[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]17,701.00[/TD]
[TD="align: center"] 5 [/TD]
[TD="align: center"] 7
 [/TD]
[TD="align: center"] 0 [/TD]
[TD="align: right"]15-11-17[/TD]
[TD="align: right"]15-10-18[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]31,052.50[/TD]
[TD="align: center"] 6 [/TD]
[TD="align: center"] 6 [/TD]
[TD="align: center"] 0 [/TD]
[TD="align: right"]30-10-17[/TD]
[TD="align: right"]30-09-18[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]26,291.32[/TD]
[TD="align: right"]$7,955.29[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]122,214.93[/TD]
[TD="align: right"]$36,980.08[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]89,015.57[/TD]
[TD="align: right"]$26,934.54[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]80,341.04[/TD]
[TD="align: right"]$24,309.78[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]65,460.50[/TD]
[TD="align: right"]$19,807.19[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]110,754.22[/TD]
[TD="align: right"]$33,512.27[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]59,964.70[/TD]
[TD="align: right"]$18,144.26[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]167,836.43[/TD]
[TD="align: right"]$50,784.34[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]47,420.81[/TD]
[TD="align: right"]$14,348.70[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]34,071.81[/TD]
[TD="align: center"] 6 [/TD]
[TD="align: center"] 6 [/TD]
[TD="align: center"] 0 [/TD]
[TD="align: right"]16-10-17[/TD]
[TD="align: right"]16-09-18[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]8,878,904.71[/TD]
[TD="align: right"]$15,677.90[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]18,225,147.01[/TD]
[TD="align: right"]$32,181.00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]33,745,489.88[/TD]
[TD="align: right"]$59,586.00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]1,117,940.41[/TD]
[TD="align: center"] 0 [/TD]
[TD="align: center"] 6 [/TD]
[TD="align: center"] 6 [/TD]
[TD="align: right"] 01-10-19 [/TD]
[TD="align: right"] 30-09-20
 [/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]
The first two months of savings
here would have in FY2017 16,631.47​
[/TD]
[TD="align: center"] 10 [/TD]
[TD="align: center"] 0 [/TD]
[TD="align: center"] 0 [/TD]
[TD="align: right"] 15-02-17 [/TD]
[TD="align: right"] 14-01-18 [/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]43,015.78[/TD]
[TD="align: right"]$60,258.00[/TD]

[TD="align: right"]08-01-17[/TD]
[TD="align: right"]12-08-17[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]7,836.04[/TD]
[TD="align: right"]$10,977.00[/TD]

[TD="align: right"]08-01-17[/TD]
[TD="align: right"]12-08-17[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]10,041.16[/TD]
[TD="align: right"]$14,066.00[/TD]

[TD="align: right"]11-10-17[/TD]
[TD="align: right"]09-11-18[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]5,319.34[/TD]
[TD="align: right"]$7,451.52[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

</tbody>

Savings Amount Local CurrencySavings Amount USDFY19 SavingsFY20 SavingsSavings Start DateSavings End Date
50

<thead>
[TH="align: center"]A[/TH]
[TH="align: center"]B[/TH]
[TH="align: center"]C[/TH]
[TH="align: center"]D[/TH]
[TH="align: center"]E[/TH]
[TH="align: center"]F[/TH]

</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]2020[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]4,535.86[/TD]
[TD="align: right"]$750.00[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]02-09-18[/TD]
[TD="align: right"]08-02-19[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]50,721.21[/TD]
[TD="align: right"]$71,052.04[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]03-01-18[/TD]
[TD="align: right"]12-03-18[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]17,701.00[/TD]
[TD="align: right"]$17,701.00[/TD]

[TD="align: right"]15-11-17[/TD]
[TD="align: right"]15-10-18[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]31,052.50[/TD]
[TD="align: right"]$31,052.50[/TD]

[TD="align: right"]30-10-17[/TD]
[TD="align: right"]30-09-18[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]26,291.32[/TD]
[TD="align: right"]$7,955.29[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]122,214.93[/TD]
[TD="align: right"]$36,980.08[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]89,015.57[/TD]
[TD="align: right"]$26,934.54[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]80,341.04[/TD]
[TD="align: right"]$24,309.78[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]65,460.50[/TD]
[TD="align: right"]$19,807.19[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]110,754.22[/TD]
[TD="align: right"]$33,512.27[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]59,964.70[/TD]
[TD="align: right"]$18,144.26[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]167,836.43[/TD]
[TD="align: right"]$50,784.34[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]47,420.81[/TD]
[TD="align: right"]$14,348.70[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]01-10-18[/TD]
[TD="align: right"]09-01-19[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]34,071.81[/TD]
[TD="align: right"]$26,426.00[/TD]

[TD="align: right"]16-10-17[/TD]
[TD="align: right"]16-09-18[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]8,878,904.71[/TD]
[TD="align: right"]$15,677.90[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]18,225,147.01[/TD]
[TD="align: right"]$32,181.00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]33,745,489.88[/TD]
[TD="align: right"]$59,586.00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]1,117,940.41[/TD]
[TD="align: right"]$1,974.00[/TD]

[TD="align: right"]10-01-17[/TD]
[TD="align: right"]12-10-17[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]16,631.47[/TD]
[TD="align: right"]$2,750.00[/TD]

[TD="align: right"]24-11-17[/TD]
[TD="align: right"]24-10-18[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]43,015.78[/TD]
[TD="align: right"]$60,258.00[/TD]

[TD="align: right"]08-01-17[/TD]
[TD="align: right"]12-08-17[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]7,836.04[/TD]
[TD="align: right"]$10,977.00[/TD]

[TD="align: right"]08-01-17[/TD]
[TD="align: right"]12-08-17[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]10,041.16[/TD]
[TD="align: right"]$14,066.00[/TD]

[TD="align: right"]11-10-17[/TD]
[TD="align: right"]09-11-18[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]5,319.34[/TD]
[TD="align: right"]$7,451.52[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]02-06-18[/TD]
[TD="align: right"]05-02-19[/TD]

</tbody>

This might not be worth the agravation!
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Need a formula to show first month of tracked savings
Replies
3
Views
106
Phuoc
P
S
  • Question Question
How many months a contract is valid for within a fiscal year?
Replies
1
Views
322
Scotty2a
S
F
  • Question Question
Changing date format based on fiscal years versus calendar years
Replies
2
Views
164
Peter_SSs
Peter_SSs
Red over White
  • Solved
Filter by specific days, months and years
Replies
3
Views
254
Red over White
Red over White
M
  • Solved
SUM OF SALES REVENUE BASED ON SALESPERSON AND MONTH OF THE YEAR
Replies
4
Views
325
meppwc
M

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top