Populate dates based on frequency

  Kiến thức lập trình

I am hoping to populate dates based on the start date and frequency up until the end date.
Input (this list will grow):
Start Date End Date Frequency Cost Category Company 02/02/2024 17/02/2024 14 545 Cow First Farmers 03/02/2024 17/02/2024 7 23 Sheep Outbacks 07/02/2024 17/02/2024 3 23 Pigs Cowboys first

Making the outpout:
Date Frequency Cost Category Company 02/02/2024 14 545 Cow First Farmers 03/02/2024 7 23 Sheep Outbacks 07/02/2024 3 23 Pigs Cowboys first 10/02/2024 7 23 Sheep Outbacks 10/02/2024 3 23 Pigs Cowboys first 13/02/2024 3 23 Pigs Cowboys first 16/02/2024 14 545 Cow First Farmers 16/02/2024 3 23 Pigs Cowboys first 17/02/2024 7 23 Sheep Outbacks

I have worked out how to get the first row, but only the date using:
=ARRAYFORMULA( IFERROR( Sheet1!$A$2 + (SEQUENCE((Sheet1!$B$2 - Sheet1!$A$2) / Sheet1!$C$2 + 1, 1, 0) * Sheet1!$C$2) ) )

I have looked everywhere online but I can’t find someone who has done this. I am happy to use any soultion that could work.

I made a example sheet so it may be easier to understand: https://docs.google.com/spreadsheets/d/1-NuaJcgDUGGt5kzqDX-dnwgfGQvNTxCkUA7oz3rOy0w/edit?usp=sharing

Apologies if this is a very basic issue

New contributor

Webber is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT