VBA - Calculate interval between two dates

[OldAndWeak182]

Hi guys,
Would you be kind enough to help me out? I hit my head all day but finally gave up.
So...

first example:
In A1 I have 01/01/2021 and in A2 I have 05/01/2021 (european date).
In VBA how can I do to calculate the range "in between" and write for example in B1 01/01/2021, in B2 02/01/2021, in B3 03/01/2021 etc?

second example linked to the first:
Same scenario as before.
This time, however, I would like to insert variables: from B1 you must always write the range of dates but skip those that have been prescribed in another specific range X of cells, better still skip them based on the color of the cell of the X range (example 02/01/ 2021 is colored red so don't write it).

Good evening

 

[OldAndWeak182]

This thing is driving me crazy: the dates are entered via two simple textboxes in a userbox.
I asked you if it could work on text because for some absurd reason the dates are entered in the US mm / dd / yyyy format and not the European dd / mm / yyyy format.
I am literally going crazy, I tried to insert different conditions to get the result but nothing seems to work.
How can I do?

Here's is the example to try: Gofile - Free file sharing and storage platform

 

[Marc L]

​

As VBA is always in US format whatever the local version so try the cell property Formula to allocate an US 'text date' …​

 

[OldAndWeak182]

​

As VBA is always in US format whatever the local version so try the cell property Formula to allocate an US 'text date' …​

I tried to indicate the format "dd mm yyyy" but it doesn't work. Could you give me an example please?
the macro works entirely, but returns the wrong results because the date is in the wrong format ... :|

 

[Marc L]

​

{Cell object}.Formula = {US text date}​

​

Replace each part between { } with the appropriate …​

 

[OldAndWeak182]

​

{Cell object}.Formula = {US text date}​

​

Replace each part between { } with the appropriate …​

Doesn't work... error runtime 6 "overflow"

 

[Marc L]

​

So you made an error in the replacement as it well works on my side since last century …​