Hi!!
I have two cells one with a date 06-01
and another with a date 06-15
the price is 1$ for a day this i can.

But in another sheet i have also 2 dates
06-10 and 07-20
the price for all days in this period is +1$

so my days in the first sheet are from 06-01 to 06-15
the days from 06-01 to 06-10 cost 1$
but the days from 06-10 to 06-15 cost 1$+1$

Is there anyone there can help me ??

Best regards alvin