Find missing days within a Range

[marcox22]

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.

 

[Special-K99]

Yes either with a formula or VBA.
But you havent stated which.