Formula to calculate cash out by weeks

Good morning

I am looking for some help to create a formula.
The formula needs to produce a value in row 9 which corresponds to the week commencing date above in row 8. For example the value in c4 will be paid 7/3/25 (21/1/25 valuation date(cell c1) + 45 days (b4) = 7/3/25 so would go into cell c9. Value in c5 would be paid 12/3/25 (21/1/25 + 50 days (cell b5) = 12/3 so would go into c9 as falls in that week. Value in c6 would be paid 22/3/25 so would go into cell e9 (21/1/25(cell c2) + 60 days(cell b6) = 22/3/25.

Many thanks in advance for your help.

Dan

Hi JeteMc

Thank you for the welcome, and a bigger thank you for the formula.

Has worked perfectly for what was needed.

Much appreciated