data from a calendar to spread sheet

I have changed my layout since no one was able to help on the previous question. I would like to have the cells in the box at the bottom left automatically look ahead 2 weeks on the top calendar and pull the job# and date then place them in the appropriate cells in the box at the bottom. The box at the bottom actual represents another sheet that will have 15 more cells between the job# and the date. Those cells have formula's based on the date of the job. My problem is I am not sure what kind of formula to put in each of the cells inorder to pull the necessary information.
Any help would truly be appreciated. I have spent 2 weeks triing to figure this one out.

Thanks,

Hello Migg,

You need to post your workbook. Pictures may be worth a thousand words, but for writing coding they aren't practical. If your workbook contains confidential information create a sanitized version for posting. If you don't know how to post your workbook, just ask. It is important to see what formulae and other macros you have, as these effect how any new code is written.

Sincerely,
Leith Ross

I am willing to send part of the workbook but I am unable to get it down to 100k. After removing as much as possible from a copy I can only get it down to 234k after I zip it. Is there another way to share the workbook?

Can I email this to someone to look at without breaking the forum rules?
Please advise someone..

Hello Migg,

You can email me a copy, and I will post the macro(s) for the forum. My email is [email protected]

Sincerely,
Leith Ross