# Thread: Interactive calendar using an array formula (2003)

1. ## 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. ## 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. ## 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. ## Re: Interactive calendar using an array formula (2003)

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

5. ## 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. ## Re: Interactive calendar using an array formula (2003)

Good guess! Makes sense to me. Thank you!

7. ## 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>

8. ## 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
•