| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting proper week
I have a dialog box with four calendars on it. What I need to have happen
is: If I click on the second Thursday of a month on calendar1 then the second Thursday of the month will be selected on the following calendar2. this is easy enough with the following code: Calendar2 = Calendar1 + 14 My problem is that if I select the 4th Thursday of the month (and it is worth noting, only the second and 4th Thursdays are used) using the code above will not necessarily get me the 2nd Thursday of the following month. For example, if I select the 4th Thursday of march (2005) the code "Calendar2 = Calendar1 + 14" gives me the 1st Thursday of April. Any creative solutions are welcome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| selecting by week number?????? | Excel Discussion (Misc queries) | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| selecting days of week using a formula in spreadsheets | Excel Worksheet Functions | |||
Threaded Mode
