Automatically list tasks in a column, that fall on a certain day, for a calendar

[trickyricky]

For example I a list that goes:
12/21......'Task A'
12/21......'Task B'
12/21......'Task C'

12/23......'Task X'
12/23......'Task Y'
12/23......'Task Z'

Okay I have a calendar set up like this:

Sun............Mon............Tues............Wed............Thurs............Fri............Sat............
12/19_____.12/20______12/21______12/22______.12/23______.12/24____.12/25_____
__________.__________.__________.__________.___________._________._________
__________.__________.__________.__________.___________._________._________
__________.__________.__________.__________.___________._________._________

Okay in each _______ I want to have it automatically fill in the tasks for each day.

Would be pretty cool if I could get this to work thanks in advance.

[outofthehat]

Take a look at http://www.excelforum.com/excel-gene...onth-wise.html, which I think is the same problem. If you don't want to use pivot tables, take a look at post 6 on that thread.

[trickyricky]

Hey great! I was able to figure it out with using a countif formula and index matches. Thanks for your time!