booking dynamic by day

[mare23]

Hi everyone!

I need your help.

The question is what the formula is if I book 2 rooms with code T1 on Apr 10 and create report on May 15 I want to show me 2 rooms.
When someone cancel those 2 rooms with code T1 on Dec 2 and I create new report on Dec 3 I want to show me 0 room.

so in the report on May 15 I have 2 rooms and in the report on Dec 11 I don't have any rooms with code T1.

Code "Booking date/
Cancelled date" Rooms
T1 10.4.2020 2
T1 2.12.2020 0

Report dates T1
15.5.2020 2
30.5.2020 2
14.6.2020 2
11.11.2020 2
26.11.2020 2
11.12.2020 0
16.12.2020 0

I hope you understand the question

Mare

 

[navic]

Try Array formula below

=MIN(IF($A$2:$A$21=$G$1,IF($B$2:$B$21<=F2,$C$2:$C$21)))

 

[mare23]

Great! That's it... thank you very much!

 

[mare23]

What if I want the sum of all? I thought it would work if I put ' * ' but nothing

Mare

 

[mare23]

Does anyone know?

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: booking dynamic by day
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.