+ Reply to Thread
Results 1 to 10 of 10

Interactive 3 month Calendar

  1. #1
    Registered User
    Join Date
    12-10-2003
    Posts
    41

    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....
    Todd P. Dolce

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Use this formula to reflect a date 3 months on

    =EDATE(A1,3)
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    12-10-2003
    Posts
    41
    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?

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Sorry, yes go to Tools, Add-ins > Analysis ToolPak

  5. #5
    Registered User
    Join Date
    12-10-2003
    Posts
    41
    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

  6. #6
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

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


    Top Excel Links

  7. #7
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Quote 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?
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    12-10-2003
    Posts
    41
    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

  9. #9
    Registered User
    Join Date
    12-10-2003
    Posts
    41
    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
    Last edited by TPD; 02-16-2007 at 04:46 PM.

  10. #10
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Quote 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: 
    7/13/07 in cell A2
    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: 
    but I still cannot get any other dates to higlight in the months ahead
    the dates you put in A3:A13 have to be within the 3 calendar ranges to highlight.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1