Expected sale for 3 months(Define next3 months after registration date and provide values)

Good evening!

Been banging my head for couple of days already and can't come up with a solution to my problem.
I'm an Excel rookie, trying to calculate for my own hustle.

I'm selling car related services, clients first purchase is represented by the "Date" column (attached example file) - after first purchase it changes to subscription that last for 3 more months
So if client made a purchase in January, next payment would be in February for 200, March for 100, and April for 100

I'm doing it manually at the moment and was wondering if it is possible to make it semi automatic, like once registration date is provided - it would automatically insert Subscription fee for next 3 months based on it?

Would really appreciate your ideas or suggestions on how and if it can be done!
Thank you in advance!

First change your header in C1:N1 to actual dates, in C2: =IF(C$1=EDATE($A2,1),200,IF(C$1=EDATE($A2,2),100,IF(C$1=EDATE($A2,3),100,""))),
copy across and down.

Hi Joseph!

I did come up with a solution yesterday, but it was rather bulky - yours is so much shorter and better in all possible ways!

Thanks you for assistance!

You are welcome, thanks for the Rep and for marking the thread "Solved".