Look through an entire wookbook to find specific dates

[badgerfan from KS]

I want to be able to look through an entire wookbook for dates and return the
tasks that need to be completed on that day. I would also like to take that
one step further and be able to look out a week ahead of time. I am running
into problems when I have multiple tasks on one day. How would this work if
I added pages in the future, would I have redo the code everytime I added
another project...

Thank-you for your help.

 

[Manish Bajpai]

Suppose, your dates are in Column A and Tasks are in
Coulmn B. Simply create a pivot taking dates and tasks on
rows side of the pivot. Then, Click on the date field in
Pivot, go to advanced options and set it to show bottom
seven dates.

Thanks,

Manish