Populate the months in-between the Start and End Date.

[VBA learner ITG]

Can I please pick your brains on this one as i'm stumped on how I will achieve this.

I have been asked to populate a month range between a start date and end date.

For example:

Column D8 = Start Date
Column D9 = End Date

Column C25 through to C36 i need to show the months between D8 and D9.

The issue I have is the start date and end date can change so i need to have the data in column C25 to C36 dynamic to accommodate this.

Any advice or pointers would be greatly appreciated.

 

[VBA learner ITG]

UPDATE:

I found the below formula which is dynamic and works on my criteria and will show only the months between the 2 dates.

=IF(C25="","",IF(EDATE(C25,1)>$D$9,"",EDATE(C25,1)))


I HOPE THIS IS USEFUL TO ANYONE READING MY POST.