Export holidays from your Outlook 2007 Calendar to an Excel worksheet

Bringing your holiday list into Excel enables you to work with various date functions, such as Workday. Here's a trick for quickly getting company holidays from Outlook 2007 to Excel.

If you have Microsoft Outlook 2007, you don't have to build a Holiday table for use in Excel functions such as Workday. You can simply export the holiday list from your company's Outlook Calendar to an Excel worksheet. Follow these steps:

  1. Open the Outlook Calendar.
  2. Click View.
  3. Point to Current View and then click Events (Figure A).

Figure A

  1. Press Ctrl + A to select all the holidays.
  2. Open a blank Excel Worksheet.
  3. Click in cell A1.
  4. Press Ctrl + V.
Depending on the holidays you have listed, your exported list should look something like Figure B.

Figure B

Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.