Update Element Entries end date when the input value date present
We have designed the recurring element with the input value as Amount and End date and the value should be like below -
Element Name: Test
Element Entry Start date: 01-04-2021
Element Input values
End date: 30-04-2021
In this case I want to end date the element entry as 30-04-2021.
If the End date is 30-09-2021 then I want to end date the element entry as 30-09-2021 but should employee paid 100.00 every month from April to September.
Can we use any fast formula to achieve this?