There's a sample file here that links tasks to a calendar based on date
and time. Maybe it will help you get started:

http://www.contextures.com/excelfiles.html

Under Functions, look for 'FN0014 - Task List and Calendar'

STO wrote:
has anyone had sucess creating a calendar from a data table in Excel?
I have a table that list items in column A and formatted dates in column B
It would be great if the items could be linked and posted on a calendar
template, either in Excel or word.
there wuld also be the need to have multiple items posted on individual days.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html