Matching dates in two different ranges

[dsjovik]

Hi
First post in the forum.
I am using Excel 2016 and do not have access to all the new array and sequence formulas in later versions or Excel365.
I want to use basic functions in Excel and not e.g. Power Query as this is for another person will no advances skills for excel fil maintenance.

Case:
I am booking a hotel stay from Date X to Date Y
The hotel has various discount periods from Date A - Date B, then another from Date C to Date D and so on.
I want to find out how many of my booked nights are in which discount periods.
My objective is to do this by using array calculations, so e.g. match Discount Period 1 to Stay Period in a Countif() statement
I have tried Row(Indirect()) to generate the arrays, but cannot figure out the syntax inside the Countif function for it.
I can list out all dates in the file and then use table or range references, but I hope to only use the start/end dates of the travel and discount periods.
Any suggestions?
I leave a screen shot of the file I am working on below

Thanks for any feedback.

 

[steve the fish]

Why not just list every date in the year with its respective discount code. Then simple countifs.

 

[dsjovik]

Why not just list every date in the year with its respective discount code. Then simple countifs.

Hi
Thanks for your suggestion
There are many hotels with varying discounts periods, as well as other discounts, so I will have to check the travel period up agains all separately.

Brs
Dagf8nn