# Formula

#### markster

##### Well-known Member
BC Plan A & B + Resources.xlsx
GHIJKLMNOPQRSTUVWXY
3Monthly CostStartEndMay-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
411,083May-23Jul-2311,08311,08311,083
Plan B - Resource Calculations
Cell Formulas
RangeFormula
G4G4=F4/12

Hello,

I have the above table. The start date in column H is the first date when a payment needs to be entered the end date in column I is the last date when the payment should be entered. I was hoping to get a formula that I can drag across that will apply the monthly cost in column G to all the dates between the start date and end date inclusive. So if May 23 is the first date July 23 is the end date it will add the amount on column G to May 23, June, 23, July 23 on that row - does that make sense? Thanks

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### Eric W

##### MrExcel MVP
Try:

Book2
FGHIJKLMNOPQ
3Annual CostMonthly CostStartEndMay-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23
413299611083May-23Jul-23110831108311083
Sheet2
Cell Formulas
RangeFormula
G4G4=F4/12
J4:Q4J4=IF(AND(J\$3>=\$H4,J\$3<=\$I4),\$G4,"")

#### markster

##### Well-known Member
Perfect Eric - thank you very much.
M

Happy to help!

Replies
4
Views
60
Replies
4
Views
337
Replies
15
Views
253
Replies
3
Views
88
Replies
2
Views
133

1,186,101
Messages
5,955,854
Members
438,221
Latest member
Salvy03

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