Hi sujeethkumar, If I am understanding the ask correctly, the user identifies the length of the period as well as M1 and you would like the rest of the 'M' fields to autopopulate. If this is the case, all you need to do is right a formula for M2-M5 that references M1. For example, M2 formula would just be M1+1 and M3 formula would be M1+2. You can add in additional logic into the formula that looks at the LEFT(New Period (Quarter) ,1) which should result in the number of months within the period.
... View more