But the problem I have 30th January and after that I have to add 1 month for every date suppose if u choose 30th January then recurring date will 28th Feb,30th March,30 th April but if I use adddays,30 then I think after january it will generate 2nd March.

Hi Arkyadeep,

So you want to generate dates by adding one month every time and your concern is that after January 30th, you wind up getting February 28th and then you get stuck in March 28th, instead of March 30th, is that it?

If that is the case, I would fix the starting date, let's say January 30th, and then add 1 month in the first iteration, 2 months on the second, and so on, but always to the starting date January 30th. In this case, you don't get stuck in February.

Hope it helps.

Regards,

João

based on date and EMI tenure i have to generate EMI date so if user entered 30th january then it is generating below emi date.but after february it is changing to 28th of every month it should be 30th of every month because user entered 30th of every month.

Hi Arkyadeep,

You are adding one month to the result of the previous row. So in your case, you get:

Row 1: 30-11-2020

Row 2: 30-11-2020 + 1 month = 30-12-2020

Row 3: 30-12-2020 + 1 month = 30-01-2021

Row 4: 30-01-2021 + 1 month = 28-02-2021

Row 5: 28-02-2021 + 1 month = 28-03-2021

You can always use the start date from your starting row. So it would be like this:

Row 1: 30-11-2020

Row 2: 30-11-2020 + 1 month = 30-12-2020

Row 3: 30-11-2020 + 2 months = 30-01-2021

Row 4: 30-11-2020 + 3 months = 28-02-2021

Row 5: 30-11-2020 + 4 months = 30-03-2021

Regards,
João