Amount of Days Between Two Dates But for Alternate Days

[new11]

Hello All,
I hope everyone is keeping healthy & happy!

Just a quick question.
I have a userform that contains four textboxes; 1x start date, 1x end date, 1x Alternate Day number & 1x result.
A user enters a starting and ending date, eg "01/oct/2020" and an end date "04/jan/2021".
In the "Alternate Day number" textbox the user enters an Alternate day number; eg "4" this represents that an action begins on every 4th day.

How could I code it so that VBA can work out the total number of Alternate days between the two dates?

Many thanks in advance!

 

[alansidman]

crosspost: Total Amount of Days Between Two Dates Using Alternate Days as a Variable

 

[Peter_SSs]

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!

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.