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