Hi,
In regard to the attachment, I would like to know what is the missing formula part (see the end of the formula syntax) that will show me 2 as result in D6.
The nights' count in column D is based on the to/from in D1 and D2. It is about rooms occupancy from/to a range of past days.
Scenario is that C6 is empty because room guest has not checked out yet and today is Aug 16th
Cheers!
In regard to the attachment, I would like to know what is the missing formula part (see the end of the formula syntax) that will show me 2 as result in D6.
The nights' count in column D is based on the to/from in D1 and D2. It is about rooms occupancy from/to a range of past days.
Scenario is that C6 is empty because room guest has not checked out yet and today is Aug 16th
Cheers!