Linking appointment dates

J

JayDee

On spreadsheet 1, I have a company name in cell A1, then in cell b1 the start
date for the company. I have a formula that calculates 6 future appointment
dates based on the start date in cell B1. The future appointment dates are
shown in cells B2, B3, B4, B5, B6, B7.

On spreadsheet 2, I have 365 cells numbered and labeled for the 365 days of
the year by Month & Date & Day of the Week.

Is it possible to write a formula to populate the company name from
Spreadsheet 1, Cell A1 in the appropriate Month & Date cell on Spreadsheet 2
for the each of the six future appointments? If it is possible to link the
spreadsheets, it would be easier and faster than manually transferring the
data from Spreadsheet 1 to Spreadsheet 2.

Example: Spreadsheet 1
Smith Company 7/1/08 8/6/08 9/10/08 10/1/08
11/5/08

Spreadsheet 2

July Aug Sep
1 2 3 4 5 6 7 etc 1 2 3 4 5 6 7 8 etc 1 2 3 4 5 6 7
8 9 10 etc
Smith Smith
Smith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top