Case Description A Setup file definitions B Date, L1, L2 stored in different columns C Date, L1, L12 , L2, L22 stored in different column (Note 4 Columns to be displayed as L1 and L2) D Date is a part of string and has a known FIXED start position E Date is a part of string and has a known FIXED start position and FIXED end position F Date is a part of string and has a known CHARACTER start position G Date is a part of string and has a known CHARACTER start position and known CHARACTER end end position. H How to use the Begin Date and End Date Database sheet. Case H: Generate Calendar with begin date and end date Step 1: Start Adv-Calendar for Excel Step 2: Clean up the Database sheet Note: Do this if you have your own data, otherwise go to step 3 Click on the Tab called Database Place cursor in cell A2 and while pressing the Ctrl and Shift keys press the Down Arrow and then Left Arrow keys. Clean the worksheet by selecting from Edit è Clear è All Step 3:  Enter the data with the following roles in a workbook: Column A: Start Date Column B: End Date   (same as Start Date if activity happened in a same day) Column C: Name Column D: Role Note: There should be no blanks in column A or B Step 4- Generate the Calendar DB Click on the button called Transfer M-Date to Calendar DB The program generates a new workbook (remember its name) From menu select Window è Advanced Calendar for Excel Click on the Tab called Database Review the errors Make sure you correct all errors and redo this process to get all of your data Step 5- Save the Calendar DB Save the newly generated Calendar DB in a folder Say C:\My_Calendar  and file name book1.xls   Close the Workbook Step 6- Open the workbook as Calendar DB From menu select Window è Advanced Calendar for Excel Click on the Tab called Setup Click on the button called Note: If you can not see this button, please click on the 3 button on the top of worksheet  Open the Calendar DB file. You should get the following Step 7- Generate Calendar using Calendar DB Make sure you enter the following      Click the button  Make sure you enter correct date and click OK Step 7- Review     And click on the C:\My_Calendar\Index1.htm