How to create a “tour for the period calendar”

[mandarp22]

Hello
I am trying to create a “tour for the period calendar” of employees please help me in this.

I have Employee Number in column A Tour Start Date in column B Tour End Date in column C of sheet 1. Now in sheet 2 cell A1 is the from date and cell B1 is to date i.e. 3-May-2014 2-june-2014 in cell C1 is Emp. No. i.e. 1002, A2 to AE2 dates i.e. 3-May, 4-May, 5-May and so on till 2-June. I want to write “T” in cell below each Date corresponding to its Start Date to End Date.
There may be more than 1 tour for the employee in the given period, i.e. 1002 6-May-2014 to 9-May-2014, then 1001 8-May-2014 to 10-May-2014, then again 1002 11-May-2014 to 15-May-2014 (this is in sheet1 column A B & C)
Regards
Mandar

 

[Somendra Misra]

Hi Mandar,

Please upload a sample file with your data and required output.

Regards,

 

[mandarp22]

Please Check the Test file

 

[NARAYANK991]

Hi ,

See your file.

Narayan

 

[mandarp22]

Hi, NARAYANK991 the file works perfect..! Thank you very much
Regards
Mandar