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?

Chip,

I will try this today! Thanks! i wasn't able to access this site for some reason (site down?) the last couple days, so I apologize for the delay...

Todd

Chip,...It's SO CLOSE I CAN TASTE IT!!!!!

The big problem now is this,.....I enter 7/13/07 in cell A2 and expect to see
the calendars reflect August, September and October....but instead it shows October November and December....Too far out....

Is there any adjustment I can make to fix this,..or will a newbie like myslef just gumm it all up beyond recognition....

UPDATE: I was able to fix the months by simply changing the formula, but I still cannot get any other dates to higlight in the months ahead...
thanks

Todd

Originally Posted by TPD

Chip,...It's SO CLOSE I CAN TASTE IT!!!!!

The big problem now is this,.....I enter 7/13/07 in cell A2 and expect to see
the calendars reflect August, September and October....but instead it shows October November and December....Too far out....

Is there any adjustment I can make to fix this,..or will a newbie like myslef just gumm it all up beyond recognition....

UPDATE: I was able to fix the months by simply changing the formula, but I still cannot get any other dates to higlight in the months ahead...
thanks

Todd

Hi Todd,

HTML Code: 

you can adjust the dates above each calendar by altering the month add-on

=DATE(YEAR($A$2),MONTH($A$2)+3,1)

HTML Code: 

the dates you put in A3:A13 have to be within the 3 calendar ranges to highlight.