I have a dataset as seen below:
Column V to X (in grey) are populated from a form. Column X is the first date we recieve payment and column V is the number of months we will receive the payment for.
I want to dynamically calculate the value of each next payment date based on the amount of payments recieved. For example in the image above for cell Y2 I have a formula =X2+30 and I dragged this to the right until it reaches cell AD2. Column V is dynamic but won't exceed 10 and I always want to increase by 30 days in each column for the number of times in V2. The example is above ie. I don't have data in AF2 or AG2 because its not needed. But if the value was 9 then it would automatically add the value =AE2+30 to that cell.
Is there a way to do this without a script?
I also want to repeat the final date in column AH2. I tried to achieve this by typing the following:
But I get too large a number. How can I correct this?