Adding Months to the data based on their start and end dates

Question

Hello,

I am trying to insert months into my volume data set based on the start and last dates (J1 and JL).

I was able to add months to the years listed, but it listed out all 12 months for each year. Some years like 2026 only have two months.

Is there a way I can add a column that will insert the correct months based on the J1 and JL dates for a specific program?

for example

11/1/2026 - 1/1/2030   Program A   volume #    Month 11 2026

11/1/2026 - 1/1/2030   Program A  volume #    Month 12 2026

11/1/2026 - 1/1/2030   Program A  volume #    Month 1 2027

I am trying to add monthly volume based on their start and end dates.

Volumes Datas.JPG

ntakeda · Accepted Answer

Hi @Destinitruth.

I will answer this question as it does not seem to have been resolved.

It can be done using the following method:

* Set the start and end dates (J1 Date and JL Date) to the first day of each month (this step is unnecessary if the data always starts on the first day).
* Add one month to the date range from J1 to JL.
* Extract the year and month from the result of step 2.

A sample file is attached for your reference.
I hope this helps solve your problem.