Month View Control to locate future date (Or Red Circle)

The reason why I need this function is for the sole purpose that I will be working with 3 userform (Calendar Control/Monthview).

The first Calendar Controls all my Worksheets that will need to have a popup calendar.

The second Calendar Control is for all userform that will need to be populated with a “click” popup calendar. I have a got a module that populates all textboxes from all userforms that requires a date.

My third Calendar Control, the one that I am working on, was a Calendar Control 2007 that when generated, generated the “Todays” date. I have 4 command button:

Cmdbutton1 was on click = Today’s date
Cmdbutton1 was on click = Today’s date + 15 making the selected date 15 days after the today’s date.
Cmdbutton1 was on click = Today’s date + 24 making the selected date 24 days after the today’s date.
Cmdbutton1 was on click = Today’s date + 15 making the selected date 40 days after the today’s date.

Now that the Calendar Control 2007 is not implemented with Excel 2010 or 2013, I need to figure out a way to have my 3rd calendar do the same thing with a monthview calendar control.

The purpose for this third calendar is that we need to select a date, if applicable, 15, 24 or 40 days after today and to show us the weekday as we cannot have it on a Saturday nor a Sunday.

I guess I could do a textbox with the monthview date and have a label to tell me when the weekday falls under.

But if there would be a easier way... It would be appreciated

Thank you,

Another solution would be but how would I obtain this:

Please Login or Register  to view this content.

So that it would show the following in the label1: If we take today date

Formula:

Please Login or Register  to view this content.

I will add it to change the label on change upon each commend button. But would need help figuring out this code as an alternative.

I have the following solution:

Please Login or Register  to view this content.

Adding the following to all my Command_Buttons:

Please Login or Register  to view this content.

I guess it will do for now until...

WOW ok now I feel a little stupid...

Just found out that when I change the "Titlebackcolor" from the properties it will go the the date that I choose if I add +(number)

Nice:

Final Code:

Please Login or Register  to view this content.