CODEWITHSUNDEEP
excelexcel-formula
JoaMika
JoaMika

Reputation: 1827

Formula to place amount on a monthly timeline

I have a monthly timeline that spans several years in columns C:AC.

I want to specify in three cells

Amount: £50
Start Date: Oct-15
Months: 6

And repeat this amount for 6 months starting October in each year, on the timeline.

Upvotes: 0

Views: 58

Answers (1)

xidgel
xidgel

Reputation: 3145

Does this help:

=IF(AND(DATEVALUE(J$9)>=EOMONTH($E106,0),DATEVALUE(J$9)<=EDATE(EOMONTH($E106,0),6)),$D106,0)

EDATE(SomeDate,6) gives a date 6 months after SomeDate.

If you need to specify a date difference that is not an integer number of months from StartDate, DATE(year, month, day) will give you more flexibility:

DATE(YEAR(StartDate)+DeltaYears,MONTH(StartDate)+DeltaMonths,DAY(StartDate)+DeltaDays))

Hope that helps

Upvotes: 1

Related Questions