Interactive 3 month Calendar

Hi,

I'm looking to have an interactive calendar created that when a specific date is entered in a cell,...example(A1)

The calendar at the top of the screen will reflect 3 months out (in a standard box looking format with the starting day highlighted in Bold. Imagine 3 calender boxes (always 3 months) and when you enter a date in cell 1,...(say 6/07/07, the calendars at the top adjust automatically so that the first box now reflects June and has the 7th day in Bold...the other two boxes now obviously reflect July, and August.

Is this a pipe dream,....a result of too much Nyquil last night,...or is this possible without being an Excel Genius?

Thanks in advance....

Use this formula to reflect a date 3 months on

=EDATE(A1,3)

Thanks,..but I think you are at level 10 with that response,..and I'm scratching my head at level 1. Is that formula based on something that I should already have loaded?

Sorry, yes go to Tools, Add-ins > Analysis ToolPak

Thanks,...but I guess it won't do what I need....Basically I want to create 3 calendar months on top...(I don't even know how to do that really) then have the interactivity based on particular cells that are populated by the user.

First action: cell A1 (which asks for month/date/yr triggers the months on the calendars to automatically adjust according to the date entered and also bolds the day selected as well.)

2nd action: cells A2:A11 (which request only the day to be entered) simply trigger the days selected to become boldface on the 3 calendars.

Does this make better sense?

TD

Hi,

Take a look at Martin's solution ...
http://www.fontstuff.com/vba/vbatut07.htm

Originally Posted by TPD

Thanks,...but I guess it won't do what I need....Basically I want to create 3 calendar months on top...(I don't even know how to do that really) then have the interactivity based on particular cells that are populated by the user.

First action: cell A1 (which asks for month/date/yr triggers the months on the calendars to automatically adjust according to the date entered and also bolds the day selected as well.)

2nd action: cells A2:A11 (which request only the day to be entered) simply trigger the days selected to become boldface on the 3 calendars.

Does this make better sense?

TD

Hi TPD,

Here's something that might fit the bill. Enter your date in A2, three calendar's automatically advance 3, 4 & 5 months ahead. Any dates entered in A3 down that fall into those calendars (Mon-Fri) are highlighted.

Hope this is what you want?