Add rows based on conditions met

I am working to transform data from monthly totals to weekly totals. I can use a simple division to break the monthly forecast into weekly totals. Each line of the data shown also has a product and plant codes in addition to the date and sum(forecast). However, the date and forecast columns are the ones that need broken down. So each 1/1/2022 date needs to be broken down to 1/3/2022, 1/10/2022, 1/17/2022, 1/24/2022, and 1/31/2022. The totals for each date would be the same for each date. How do I add rows for the adjusted dates with the new forecast totals?