Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interactive calendar using an array formula (2003)

    I am trying to recreate a tip that John Walkenbach put in his book, "Favorite Excel Tips & Tricks," in which he used a complex array formula to create an interactive calendar. It sort of works. I am attaching it and would very much appreciate any help you can give me with this. For some reason, the dates start with the 29th and 30th as the first two days of the month. I have painstakenly triplechecked the formula to be sure I am doing what he instructed. For the life of me, I can't find the mistake. I would ask him, but I can't figure out how to when I go to his site.

    Thank you!

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interactive calendar using an array formula (2003)

    oops.. I noticed some xtra stuff on the bottom of that calendar spreadsheet. Sorry... ignore it. I only care about the calendar.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Interactive calendar using an array formula (2003)

    Change the last -1 in the formula to +1.

    Remember: you must select the entire range with the array formula (B4:H9), modify the formula, then confirm it with Ctrl+Shift+Enter.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interactive calendar using an array formula (2003)

    Ok that worked. But why? What is the significance of the -1 and +1?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Interactive calendar using an array formula (2003)

    I won't pretend that I understand the formula. It's just that, as you noted, the dates were 2 days too low, so I thought that adding 2 might help. This could be accomplished by adding 1 instead of subtracting. And it worked... <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interactive calendar using an array formula (2003)

    Good guess! Makes sense to me. Thank you!

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Interactive calendar using an array formula (2003)

    Melanie

    If you have a chance can you reply with the ISBN for this book or PM it, either way, looks pretty cool <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Jerry

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Interactive calendar using an array formula (2003)


Posting Permissions

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