Price calculations between dates

[Elephant]

Hi Shay,

I put up a new thread. I started by asking my original question again, mainly becuase I am not sure of the technicalities behind what the date thing you were trying to solve ... maybe you could ask that as a seperate thread, and one way or the other we will get there.

Thanks for all the time you spent - really appreciated!

 

[shay]

Steve

I'm sure the calculation could be done by a formula but it would be complicated because you need to select a price for each day of the stay depending on the hotel and room type.

I chose to use code as I thought it was easier to use a Do Loop to build up the total price.

Anyway, I hope you get lots of replies and a solution soon.

shay