Formula

markster

Well-known Member
Joined
May 23, 2002
Messages
575
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
Joined
Aug 18, 2015
Messages
12,597
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
Joined
May 23, 2002
Messages
575
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Perfect Eric - thank you very much.
M
 

Forum statistics

Threads
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.
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
Top