Insert flexible sequence of Months

[Justerbox]

Dear all,

I would like to request some help on a excel problem.

I used the formula presented by Weaver here: Copy rows in excel multiple "n" times

It works perfectly, but now I want to add something to the multiplied rows.

I have a Invoice for a varying daterangerang (can be between 1 and 36 months)

Invoice	Start date	End Date	Number of months
300​	01.01.2021​	31.03.2021​	3​
500​	01.01.2021​	31.05.2021​	5​
200​	01.01.2021​	28.02.2021​	2​

Should turn to something Like this

Invoice	Date of Invoice	Start date	End Date	Number of months
300​	31.01.2021​	01.01.2021​	31.03.2021​	3​
300​	28.02.2021​	01.01.2021​	31.03.2021​	3​
300​	31.03.2021​	01.01.2021​	31.03.2021​	3​
500​	31.01.2021​	01.01.2021​	31.05.2021​	5​
500​	28.02.2021​	01.01.2021​	31.05.2021​	5​
500​	31.03.2021​	01.01.2021​	31.05.2021​	5​
500​	30.04.2021​	01.01.2021​	31.05.2021​	5​
500​	31.05.2021​	01.01.2021​	31.05.2021​	5​
200​	31.01.2021​	01.01.2021​	28.02.2021​	2​
200​	28.02.2021​	01.01.2021​	28.02.2021​	2​

I can provide my code that I have at the moment, but there is quite a mess going on to be honest, as I combined and recorded multiple macros.

 

[KRice]

Try copying this formula into the top cell of your Date of Invoice column (assuming that would be cell B2) and then copy down:

=EOMONTH(EDATE(INDEX($C$2:$C$11,MATCH($A2,$A$2:$A$11,0)),COUNTIF(A$2:A2,A2)-1),0)

 

[Justerbox]

Thank you very much KRice. I knew I was overthinking the Problem and there was a "simple" solution.

 

[KRice]

I'm happy to help...and welcome to the board!