Calendar to do list

[JWilkins3]

Hi all,

I have created a calendar in excel that I can track the ongoings for each month.  I have set it up so that each day has a set of 5 cells below it so i can add 5 things per date.  I was wondering if there was a way to create a 'monthly' to do list on a separate sheet that would automatically add things to it that I am typing in the calendar month sections.

I don't mind if i end up having to do each date per month with a formula i just really need a work around so i can see tasks/events filtered by the conditional formatting or by the date.

bonus points if the to do list can be split up into monthly sections on the list!

Any advice would be appreciated!

Thank you

Gray 

[#2]

How about Android calendar/outlook calendar which provide both week and monthly view of actions?

[#3]

IT's for planning annual charity events so we just have a calendar view of events which i can then allocate volunteers... I wanted to be able to put in the date on the to do list and the text typed be allocated to the appropriate section on the calendar/sheet... But i realise it is probably a huge complex work around, i was just playing around to see if it was possible and if i could do it. Thank you so much for your suggestion, it may be what we have to go to in the long run...

[#4]

If you use Android calendar,you can convert your excel worksheet to a .ics file and imported to Android calendar.

[#5]

ooooh! Thank you I didn't know this!