ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar Control (https://www.excelbanter.com/excel-programming/365248-calendar-control.html)

Patrick Simonds

Calendar Control
 
Not sure where my post went but I cant see it so sorry if this is a
duplicate of sorts.

I asked how to make a Calendar control (on a dialogbox) open with today's
date. I figured that out:

Calendar1.Value = Now()

But what I need it to do is display the date of the next Tuesday 2 weeks
from today. Hope that makes sense.

Examples:

Today is Friday 21 June date selected on the Calendar control should be 4
July,
Today is Sunday June 25 date selected on the Calendar control should be 11
July




All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com