Payment dates VBA

Howdy

I've tried to come up with ideas to solving the problem i'll present through formulas. But now i'm inclined to think that the most optimized solution will be rendered through VBA.

The problem follows

Payment dates
->05/XX/XX
->15/XX/XX
'Bills are expected to be paid at the rigid dates above. If a bill is received after the 15th of the current month, it'll be then be paid at the 5th day of the following month'

Example
Bill delivered_______Expected payment date
02/01/2019________05/01/2019*
09/01/2019________15/01/2019*
28/01/2019________05/02/2019*
'the asterisk represents the field in which a formula or a VBA code should apply, to show the expected payment date'
'the field bill delivered is automaticly extracted from the system'

The questions:
1) Would it be possible to get this done by just using formulas?
2) Even if its possible to get the expected result by just using formulas, how would a VBA code look like in this case?
2.1) I ask this because my sheets usually have over 50k to 60k lines and about 40 columns of other information. All this renders the workingsheet
heavy as it is. I believe by executing the macro is the most light weight method to the expected result.

Any ideas?

Thanks!

PS: I started learning excel about 5 months ago, and most specificly VBA about a week ago.
I'm loving using this forum. And dang sure i'm loving to learn how to code in VBA.

Hello,



This can be achieved quite easily with formulas by using an if statement. please provide sample data in a workbook similar to your layout for us to look at.

Originally Posted by ironfelix717

HI,

Disregard a sample.
See attached which uses an IF statement to calculate your dates.

You will want to note that the date format is US and not European (mm/dd/yyyy) vs (dd/mm,yyyy). You can change this with cell formatting.

Thats pretty much straight forward as you can get.
How would a three date setting look like? (eg. 10/xx/xx, 20/xx/xx, 30/xx/xx) Would it be =(if(if))?

Originally Posted by KarelMusa

Thats pretty much straight forward as you can get.
How would a three date setting look like? (eg. 10/xx/xx, 20/xx/xx, 30/xx/xx) Would it be =(if(if))?

Hi, I'm not sure what you mean. The sample workbook I attached contains a date format of mm/dd/yyyy.

Changing how the date is formatted should be as simple as changing the cell format