I am trying to draw a spin button on a userform, in order to generate the date of the 3rd friday of each month that is after the current date (today). In order words, the coming 3rd friday will be the earliest date available.
For example, the date of every 3rd friday of the month will be shown with every incremental change of the spinbutton as below:
However, the 19/3/2010 should not be given since it has already over and on 17/4/2010, the earliest date will be replaced by 21/5/2010 as 16/4/2010 will become unavailable.
It would be great if you could help me up with this as i'm new to spin button. Should i predefine a list of date or is there any excel formula that can help to identify them?