Increment by number of days or weeks

Hello all,

At the example I attach you will see a table with days and weeks
Also two dates FROM and TO.

At the table you will also see next to days or weeks the number that the cost should increment if the days (or weeks) between FROM and TO.
Can this to be done automatically and better if it can be done with VBA somehow.

Thank you in advance,

Gerasimos

There is really no need or benefit to using VBA for this. Also, your data layout design needs a change to be fully effective. See attached.

In B18, use this:

Please Login or Register  to view this content.

WBD

I agree with Jeff's comment.

I'd just put this one together which includes a lookup table but WideBoy's offering is much better.

@6StringJazzer yes you are correct, I dont need VBA but I cannot change the table if it is possible. Thats why I was thought about VBA. But your way sure works . Your solution the result is 900

@WideBoyDixon thank you, and with your solution the result is 1050

No VBA required. See the ranges used carefully.
In C18

Formula:

Please Login or Register  to view this content.

Alternatively I have used E16 and B18.

Originally Posted by gerasimos

@WideBoyDixon thank you, and with your solution the result is 1050

Huh? See the attached image.

WBD