=(Sheet1!A2-Sheet1!A1+1)*1 + (Sheet2!A2-Sheet2!A1+1)*1

So the overlap would be 1 + 1


--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
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