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

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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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
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]
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
Are you able to populate some of your sample rows so I can work on modifying the formula?

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

Forum statistics

Threads
1,223,900
Messages
6,175,276
Members
452,629
Latest member
SahilPolekar

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