Find missing days within a Range

[Marco Verace]

Hi guys!
I would need to know if some days are missing, see the example below please.

I have a range of days like this : 
01JAN19 - 20JAN19
24JAN19 - 30JAN19

I'd like to get an output of the missing days:

• 21JAN19
• 22JAN19
• 23JAN19
• 31JAN19

Do you have any advice on how to build it?
Thank you very much in advance for the help

[#2]

Your logic does not seem to be correct.

your range does not have 31 Jan 2019 then why to list 31JAN19 in the missing dates?

[#3]

Jamil, I guess these are all days in Jan 2019 which are not in ranges

[#4]

Hi Mohammad, thanks for the reply.

Apologises if I did not express my self properly.

As 31JAN19 does exist in reality, I would consider it as a missing date considering the data I have been provided.

Edit: Exactly as Sergei said

[#5]

Another question how many such ranges could be (here we have two)

[#6]

I have two ranges each time, but different example to analyse.

Thanks,

Marco

[#7 · Accepted solution]

Please see attached workbook that i have embedded the formula.

[#8]

Thank you very much!

Absolutely what I needed!

[#9]

You are welcome.