How to create a countdown calendar in Outlook?



I want to automate a countdown entry in my Outlook 2007 calendar.

January 26 - 100 weeks until retirement
Feb 2 - 99 weeks until retirement
Feb 9 - 98 weeks until retirement

etc, etc.
Obviously, I don't want to do this manually. I've tried importing a
countdown from Excel using these instructions, but no dice.

Diane Poremsky [MVP]

What part of the instructions didn't work? It's the easiest method to use.
The most common error is with the named range in step 6. See for a tutorial for
named ranges.

Diane Poremsky [MVP - Outlook]

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting or point your
newsreader to
Feb 14, 2013
Reaction score

I want to thank the OP for this.
I just had the need to create a countdown today and found this post to be spot on!
I am using Office 2010 and the directions fit perfectly!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question