Part 3: Import the CSV file into Outlook calendarĨ. So far the workbook has been saved as CSV file already. Note: If dialog box pops out to warn you some features will be lost if saving as CSV file, please click the Yes button.

In the opening Save As dialog box, please (1) specify the destination folder you will save the CSV file into, (2) type a name for the CSV file in the File name box, (3) select CSV (Comma delimited) from the Save as type drop down list, and finally (4) click the Save button. Click File > Save As to save the workbook as CSV file.ħ. Part 2: Save the recurring appointment data as CSV fileĦ. So far you have prepared data for the recurring appointment in Excel as below screenshot shown: Please type in data in the Subject, Start time, and End time columns as you need. Note: In the formula, C1 is the year you will calculate the first business day within, E2 is the first month of the specified year, C2:C11 is the range containing holidays in the specified year.ĥ. Go to the 1st Business Date column, type =WORKDAY(DATE($C$1,E2,1)-1,1,$C$2:$C$11) into Cell G2, and then drag this cell’s AutoFill handle down to Range G2:G13. Enter from 1 to 12 into the Month column.Ĥ. Note: Click to know how to figure out all holidays with formulas in Excel.ģ. In my example, I type in holiday names in the Holiday column, type in holiday notes in the When column, and then type holiday dates in 2017 column (2017 is the specified year I will schedule the recurring appointment in). Please type in holiday data in Column A:C as below screenshot shown: Launch Microsoft Excel, type in column headers as below screenshot shown:Ģ.

Part 1: Type in recurring appointment data in Excelġ. Therefore, this method will guide you to figure out these irregular dates in Excel, and then import them into Outlook calendar. obviously, the first business day of every month doesn’t repeat regularly. Outlook can only schedule a recurring appointment which repeats regularly, such as 1st Monday of every month, the Monday of every weekly, or every weekday, etc.

Outlook recurring task