Adobt Formula for new condition

Dear All,

My excel file is attached. Once Forum Contributor XLENT advised me a perfect formula (in B9) can calculate all possibilities regarding to the criterias above. My question is how can it be modified to calculate over the CHECK-IN day price not considering the period break?

I mean if I choose 29.04-06.05 of 7 overnights (the Check-Out day of 06.05 always excluded), the current formula calculates 2 nights (29-30.04) from 72 and 5 nights (01-05.05) from 78 which is giving accurate result (534) considering period break on 01.05.

So how the formula can be adobted if being calculated over the 1st day (Check-in day) price only with respect to criterias above. In that case calculation would be 72 * 7= 504 without considering period break on 01.05.

Thanks in advance for your kindest helps.

Dear Bo-Ry thanks indeed for your great prompt works excellent. Regards