Thread: Excel Calendar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davids davids is offline
external usenet poster
 
Posts: 10
Default Excel Calendar

Hi there,

I am trying to create a calendar for tasks I have to do at work so in column
A i have all of the days in the year I plan to put my tasks in column B. I
was wondering whether there is a way to first of all lock column A so I can't
delete any days of the year and secondly if i move a task down the list to
another day I would like it to skip the cells corresponding to Saturday and
Sunday and move into the cell next to Monday and shift all other task down
too while always skipping Saturday and Sunday.

Is this possible?

Thanks!