Divide 2 dates into months

[Somvanshi]

I have 2 dates Period Start and Period End and 1 amount column in my data. I want monthwise amount based on these dates.

For e.g. if Start Date is 25 Apr 2021 and End Date is 30 Jun 2021, total amount is 2000 then i was the bifurcation if amount based on month like for 5 days of Apr the amount similarly for whole month of May and then June.

[binuacs]

@Somvanshi Can you provide the expected output based on the input file provided?

[Christina_H]

Is this what you want?

[egregorio001]

Hey @Christina_H, This helped us a lot today. Thank you!