Formula

[markster]

BC Plan A & B + Resources.xlsx
	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
3	Monthly Cost	Start	End	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24
4	11,083	May-23	Jul-23	11,083	11,083	11,083
Plan B - Resource Calculations

Cell Formulas
Range	Formula
G4	G4	=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

 

[Eric W]

Try:

Book2
	F	G	H	I	J	K	L	M	N	O	P	Q
3	Annual Cost	Monthly Cost	Start	End	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23
4	132996	11083	May-23	Jul-23	11083	11083	11083
Sheet2

Cell Formulas
Range	Formula
G4	G4	=F4/12
J4:Q4	J4	=IF(AND(J$3>=$H4,J$3<=$I4),$G4,"")

 

[markster]

Perfect Eric - thank you very much.
M

 

[Eric W]

Happy to help!