I have a manually updated date in cell $a$6.
I am trying to calculate the difference in months between $a$6 and e9 and multiply it by a set field (a number) in cell $d$9. Then I am trying to look four years out - so I am currently in year 1, but for years 2-4 they have blank cells. Each of the difference in months will need to be multiplied by the set value in $d$9. The date for year 2 is in h9, the date for year 3 is in k9, and the date for year 4 is in 9. Basically, I am trying to calculate a cumulative premium I am getting during the course of these years. There could be breaks in dates so I can use a standard term.
The current formula I have is =((MONTH($A$6)-MONTH(E9))*$D$9)+((MONTH($A$6)-MONTH(H9))*$D$9)+((MONTH($A$6)-MONTH(K9))*$D$9)+((MONTH($A$6)-MONTH(N9))*$D$9)
The first set ((MONTH($A$6)-MONTH(E9))*$D$9) calculates correctly - it is the following sets that do not add correctly. When I do the second set by itself it comes back with a value even though the cell is blank.
Any help is greatly appreciated!
I am trying to calculate the difference in months between $a$6 and e9 and multiply it by a set field (a number) in cell $d$9. Then I am trying to look four years out - so I am currently in year 1, but for years 2-4 they have blank cells. Each of the difference in months will need to be multiplied by the set value in $d$9. The date for year 2 is in h9, the date for year 3 is in k9, and the date for year 4 is in 9. Basically, I am trying to calculate a cumulative premium I am getting during the course of these years. There could be breaks in dates so I can use a standard term.
The current formula I have is =((MONTH($A$6)-MONTH(E9))*$D$9)+((MONTH($A$6)-MONTH(H9))*$D$9)+((MONTH($A$6)-MONTH(K9))*$D$9)+((MONTH($A$6)-MONTH(N9))*$D$9)
The first set ((MONTH($A$6)-MONTH(E9))*$D$9) calculates correctly - it is the following sets that do not add correctly. When I do the second set by itself it comes back with a value even though the cell is blank.
Any help is greatly appreciated!
