Calculating next date

Hi,
I am trying to calculate the next payment date based on a series of assumptions about payment start date, model start date and frequency of payment.

On cell D2, I am trying to calculate the next payment date, after the model begins. I’ve made the following assumptions:

1. My payment start date is January 2nd
2. My Model start date is February 1st.
3. I pay every 7 days.

I know from manual calculation that my next payment is February 6th (see cell A7) but on cell D2 I want to be able to calculate this, so that if I change any of the inputs on cells, A2, B2, or C2, the next payment date will automatically flex.

Any help is sincerely appreciated.

What is the desired output in D2 , tell me verbally as i am not able to understand your requirement

Punnam

Maybe like this

=A2+CEILING(B2-A2+1,C2)

That Ceiling formula is excellent! Thank you