Formula for billing statement between bill cycle date and bill due date?

excel.PNG








Hi everyone,
I hope you can help me guys in creating a formula to determined the correct due date within 6 months promotional plan.
If I charge my card 1/01/2019 and my billing cycle date is every 5th of the month and my due date is every 1st of the month.

Tnx guys!

Hello etonsketon and Welcome to Excel Forum.
If you could tell us which cell(s) you want to populate and what the expected value(s) is/are, then we may be able to write formula(s)/code to automate the process.
Let us know if you have any questions.