Need help with Sequence function to list out dates properly.
In attempting to create an Amortization Table, I’m having trouble filling out my Date column using the Sequence formula. I want the first date (Cell C10) to show the 15th day of the month following the “Initial Date” in cell D5. In this example, Cell C10 should show “12/15/2022” then all the following cells should be spilled out (using the 1st day of the month) because of the number of payments shown in cell H3. I’m new to the SEQUENCE formula. So, please tell me what I’m doing wrong. (Hopefully my screenshots show up below.) The 2nd pic seems to be closer to what I need. but putting 30.437 in the STEP section of the Sequence formula doesn’t seem to be the right option either. Please help!!
In attempting to create an Amortization Table, I’m having trouble filling out my Date column using the Sequence formula. I want the first date (Cell C10) to show the 15th day of the month following the “Initial Date” in cell D5. In this example, Cell C10 should show “12/15/2022” then all the following cells should be spilled out (using the 1st day of the month) because of the number of payments shown in cell H3. I’m new to the SEQUENCE formula. So, please tell me what I’m doing wrong. (Hopefully my screenshots show up below.) The 2nd pic seems to be closer to what I need. but putting 30.437 in the STEP section of the Sequence formula doesn’t seem to be the right option either. Please help!! Read More
