# Difference in Dates Multiplying buy a value

#### whistope

##### New Member
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!

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Replies
1
Views
162
Replies
2
Views
215
Replies
10
Views
367
Replies
2
Views
212
Replies
4
Views
155

1,206,754
Messages
6,074,750
Members
446,083
Latest member
kfunt

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

### Which adblocker are you using?

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

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