Creating a calendar; moving data within it

I am trying to create a calendar for work that will help me keep track of my projects and enable me to easily share with my manager what I'm working on day-by-day.

I need the calendar to traverse months, and I need it to be flexible enough that I can delete or add data to one day and have subsequent data then readjust itself row by row. In its natural state, Excel operates line by line. If I delete a cell on the April 12th, for example, I could shift data within the calendar, but only for that week. The following week is on a new row and is not connected to the row before it, so it wouldn't shift.

I'm sure there's a way to manipulate Excel to do this. It seems that there are a host of things that Excel can do if you only know how to speak its language. I do NOT speak Excel-ese. :(

Any help?

 So, for example, if I wanted to add something on Friday on Cinco de Mayo, I would want to shift all of my tasks one cell to the right-- but I would want/expect my Sunday, May 7 task "Catalog files" to move to Monday, May 8. Excel doesn't function like that naturally, but how can I tell it to? (Similarly, if I realize I need to delete something and move all the tasks backwards by one or two cells... how would I do that?)