After looking into this further, I think my requirements are such that it
cannot be handled through cell formulas. The range of data that I would
process would be a minimum for 1 year (365 lines ) and could be as much as 3
years (3 * 365 lines). I figure I would need a macro that will loop through
raw data and output it as a condensed yearly calendar...


"haileybury" wrote:

Thanks a lot. I will look into tweaking this to meet my specific requirements.

Regards

"Debra Dalgleish" wrote:

There's a sample file here that will display a list of tasks in a weekly
calendar view:

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

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

haileybury wrote:
Wondering if there is a macro around that can interpret a list of data
(within a dae range) and display them in a calendar view. This will help to
visually analyse for trends in events that occur on certain days of the week.


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