• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Outlook Tips

Learning Microsoft Outlook One Tip At A Time

Diane Poremsky [Outlook MVP]

  • Home
  • Tips Archive
  • How to...
  • Beginner
  • Outlook.com

Create Countdown Calendar in Microsoft Outlook

Create countdown appointments
Outlook doesn't support creating calendar items that countdown (or count up) to a specific date. You'll need to create each item individually and the easiest way to do this is outside of Outlook and import the file to the Calendar. You can use this method with any version of Excel and Outlook, although some steps might be slightly different in older versions of either program.

If you have another spreadsheet program, such as Works, you may need to save it as a CSV or text file to import into Outlook.

Create your series in a spreadsheet program

Create countdown appointments in ExcelExcel makes it very easy because it allows you to drag and fill cells in a series, changing the numbers in each row.

  1. At the very least you need two columns, Date and Subject. (Outlook uses Start Date, not Date as used in my examples, and you can save a step if you use Start Date.)

    Tip: A Categories field will make it easier to delete the items if you make a mistake when importing.

    If you want to use other fields, create one sample record in an new calendar folder and export it to Excel so you know what fields you need. This will eliminate the need to map fields during the import process.

  2. To begin with "today", press Ctrl+; (semi-colon) in the first data row of the date column.
  3. Select the cell and drag down to fill the column with consecutive dates, stopping at the date you are counting down to.

    Common Excel tricks such as entering two non-consecutive dates in a column and dragging allows you to create a pattern, such as weekly (as shown in the screenshot) or every other day. (You can use this with birthdays too.)

    If the fill doesn't use a series, click on the Smart tag and choose series.

  4. Go to the last date and enter your subject line. Use a number as the first or last character and Excel will complete the series when you drag. Either type the subject line twice or drag it up one cell and change the 0 to 2, as I've done in the screenshot.
    Create countdown appointments for Microsoft Outlook
  5. Select both cells in the subject column and drag up. Excel will complete the series.
  6. Save the workbook, choosing CSV format, then close it
  7. Save as CSV format

Create a named range

Note: you can save the workbook in Excel format or CSV but if you use Excel format you need to create a named range for your data. Because using CSV is basically fool-proof when importing from a spreadsheet, I've updated the steps to use CSV.

When you use named ranges, you need to verify that all data you want to import is within the named range; using CSV format automatically includes all fields in the sheet. There are situations where it makes sense to use named ranges, such as if you have fields in the spreadsheet that will not be imported. If you need to import from multiple sheets in the same workbook, using named ranges will save a couple of steps.

Now it's time to import it into Outlook.

  1. Select File, Import and Export
  2. Select Import from another program or file.
  3. Select the program or file type.
    If you used CSV, choose "Comma Separated Values (Windows)".
    If you saved the file in Excel (*.xls) format, choose Microsoft Excel.
    Choose the file type for import
  4. Browse for the file. (If the file is still open in Excel, it will cause an error.)
  5. Select the Calendar folder you want to Import the file into.
  6. Outlook doesn't recognize Date, so I need to drag it to Start Date and Outlook adds it to the Mapped From column next to Start Date.
    Create countdown appointments for Microsoft Outlook
  7. Click Finish to import your items.

Create countdown appointments for Microsoft Outlook

Other Uses

You can use this method with birthdays so the subject contains the person's age:

Mark is 1
Mark is 2
Mark is 3

If you want the appointment to say "Mark is 1 today" you'll need to learn how to use a concatenate formula and Copy, then Paste Special, Values to create your subject field. (=CONCATENATE(cell,cell).

Published May 13, 2011. Last updated on October 25, 2020.

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • More
  • Print
  • Tumblr
  • Reddit
  • Pocket
  • Pinterest

Related posts:

Do you need to convert a distribution list to individual contacts?  Although Outlook doesn’t have an option to save individual conTip 529: Create Contacts from a DL Export Outlook Calendar to use in Windows 7 or Vista Do you want to show a 7-day calendar in the day planner column format, like the day and work week views use? It's easy. If youTip 318: Display 7 Days in the Calendar Do you want to countdown the days (or weeks) until vacation? Do you want to know someone's age on their birthday? Outlook doesTip 237: Create Countdown Appointments
Subscribe
Notify of
41 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Primary Sidebar

Search OutlookTips

Training and one-on-one assistance

Do you need help setting up Outlook or want some one-on-one training? I'm available for hire. See Training and one-on-one assistance for fees and to check availability.

All-Time Most Popular Posts

  • Windows 7 and Vista Start Search field
    How to start Outlook in safe mode
  • outlook.com icon
    Delete a message stuck in Outlook's Outbox
  • How to use Outlook's Command line switches
  • Use Cleanviews switch to reset all views
    How to Reset the View on Outlook folders
  • Where are my Outlook Files?
  • Folder paths
    How to Find Folder Paths in Outlook Mailboxes
  • How to use Scanpst.exe to repair Outlook data files
  • Outlook's Missing Holidays
  • backstage page
    Where is File tab in Outlook?
  • Icons found in the Inbox, Message Headers, and Toolbars

Footer

Recent Posts

  • Log into multiple Outlook on the web accounts
  • Keeping Hackers out of Microsoft accounts
  • Microsoft Account Closure Email
  • Outlook on the web Quick Actions moved to the right
  • Automatically sign out of Outlook.com

Recent Bug List

Microsoft keeps a running list of issues affecting recently released updates at Fixes or workarounds for recent issues in Outlook for Windows.

Office Update History

Update history for supported Office versions is at Update history for Office

Resources

Ask questions and share your knowledge in Outlook Forums.

You Might Like

Where is File tab in Outlook?
Using Two-factor authentication
Where are my Outlook Files?
How to use Outlook's Command line switches

© 2003–2025 · Outlook Tips

wpDiscuz
You are going to send email to

Move Comment