I've created a Gantt-chart-style Pivot Table that shows a start date and end date for each Project in the List...So for example, you could have

Column A Column B Column C
Project Start Date End Date
----------- --------------- ---------------

Project A 01-Jan-2014 31-Dec-2014
Project B 01-Jun-2014 11-Jul-2014
Project C 07-Jul-2014 18-Jul-2014

To the right of the Pivot Table columns, I've created Columns for each week starting in July 2014 and running through June 2015

For example:

Column A.........Column D Column E Column F
Project Week 1 Week 2 Week 3
June 29, 2014 July 6, 2014 July 13, 2014
July 5, 2014 July 12, 2014 July 19, 2014
---------- ---------------- --------------- ---------------
Project A X X X
Project B X X
Project C X X

I want to put an X in each week column if the start and end date falls in the column week.

How can I get the Range Row Number/Address for each Start Date and End Date combination so that I can use the Row Number/Address for the corresponding column week cells?

Thanks