Linked Questions

Popular Questions

I have a dataset as seen below:

enter image description here

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:

enter image description here

But I get too large a number. How can I correct this?

enter image description here

Related Questions