Schedule (Move backward in case holiday)

[KIM Chanthan]

Hi,

Do you have any idea to solve my problem?
I have made on payment schedule. Normally, the collected date should be on the same date in next month comparing to disbursed date, but in case it falls on Holiday, I want to move backward to working day.

Please view attached file for more detail.

Thanks for your time and kind help.

 

[vletm]

KIM Chanthan
Could this solve Your challenge?
Modify Cell's F2 value and press <ENTER>.

 

[NARAYANK991]

Hi ,

See the attached file.

I have used 2 helper columns so that you can follow the logic and verify that it is correct.

Narayan

 

[KIM Chanthan]

KIM Chanthan
Could this solve Your challenge?
Modify Cell's F2 value and press <ENTER>.

It is really solve my problem. However, as i very basic in VBA, i cannot find your code as i need it to apply to my real template. It would be perfect if you can guide me how to find your code.

Thanks,

 

[KIM Chanthan]

Hi ,

See the attached file.

I have used 2 helper columns so that you can follow the logic and verify that it is correct.

Narayan

It's very useful. Now i am learning about your formula.
Is there any more way if i don't want to use array formula?
Thanks alot :D

 

[vletm]

KIM Chanthan
Open Visual Basic Editor ...
from Sheet1 (Sheet1) select 'View Code'
and
from there, You'll find it.