Can you help me with the following.
In excel I need to calculate how long somebody stays and a apply a different fee.
between 1 and 7 nights 1,5 euro
between 8 and 14 nights 2,1euro
longer then 15 nights longer no extra charge.
do you have an idea? please no vsb..